Using the Count function to count how many times a answer occurs

[jcazzato]

Hi everyone,

We're having some trouble with using the count function

Basically we want to count evertime the North or South pump is running in location Roughing Mill - Stand 1. 

The most difficult part of this is other 'Locations' may have the same 'VALUE_FINAL' answer. i.e. NORTH or SOUTH

	Checklist	Location	Question	VALUE_FINAL	ANSWER_COMMENT	Role
27/04/2019	Days Lube Inspections	Roughing Mill - Stand 1H	NORTH or SOUTH pump in use ?	NORTH	-	Mechanical Craft
26/04/2019	Days Lube Inspections	Roughing Mill - Stand 1H	NORTH or SOUTH pump in use ?	SOUTH	-	Mechanical Craft
25/04/2019	Days Lube Inspections	Roughing Mill - Stand 1H	NORTH or SOUTH pump in use ?	SOUTH	-	Mechanical Craft
24/04/2019	Days Lube Inspections	Roughing Mill - Stand 1H	NORTH or SOUTH pump in use ?	NORTH	-	Mechanical Craft
16/04/2019	Days Lube Inspections	Roughing Mill - Stand 1H	NORTH or SOUTH pump in use ?	SOUTH	-	Mechanical Craft
15/04/2019	Days Lube Inspections	Roughing Mill - Stand 1H	NORTH or SOUTH pump in use ?	SOUTH	-	Mechanical Craft
12/04/2019	Days Lube Inspections	Roughing Mill - Stand 1H	NORTH or SOUTH pump in use ?	SOUTH	-	Mechanical Craft

Any help will be greatly appretiated 

Thank you,

Jo

[JordyWegman]

Hi Jcazzato,

Create two KPI objects with these measures, one for each:

// First one is for south
Count({$< Location = {'Roughing Mill - Stand 1H'}, VALUE_FINAL = {'SOUTH'}>}Location)

//Second one is for north
Count({$< Location = {'Roughing Mill - Stand 1H'}, VALUE_FINAL = {'NORTH'}>}Location)

Jordy

Climber