3 Replies Latest reply: Sep 6, 2016 2:02 AM by Lukas Roček

# Count of maximum values in KPI

Hello, I have report from repair, where repairists doing repairs on some counts of steps. Sometimes 2 steps, sometimes 5 steps.... I need count of maximum values for each repairist. for example -> I will click on Jacob on bar chart, and I would like to see next to bar chart in KPI, that he had 5 times 3 steps (3 is maximum of his values of steps - this value I have on other bar chart).

My bad solution: count (aggr (max([count_of_steps]),EAN))

• ###### Re: Count of maximum values in KPI

Hey there,

Regards,

MB

• ###### Re: Count of maximum values in KPI

I will upgrade my ask a little bit. I have table with columns: EAN,  ID OF REPAIRIST, NOK REPAIR(1 is true, 0 is false), STEP OF REPAIR (when is EAN similar and ID OF REPAIRIST is similar and time of repair is above 20 minutes, then is STEP OF REPAIR +1 and TIME OF REPAIR). I need 4 KPIs : The first will be: count of EANs, witch were OK on first time. Second KPI will be: count of EANs, witch were OK in two steps...etc to >5 steps...

So, I know for each row: Operator, if was it mistake in repair (0,1), number of step... I dont know, whether AGGR is good solution, but I would like to solve this problém thanks for your answers

• ###### Re: Count of maximum values in KPI
 ID EAN STEP OF REPAIR MISTAKE TIME, WHEN IS MISTAKE (mistake is above 20 minutes) TIME OF REPAIR REPAIRIST NO. 177 EANO87B2R5 1 0 - 2:16:37 52726 180 EANO87B2RF 1 0 - 1:47:51 52726 181 EANO87B2RT 1 0 - 2:10:31 52726 182 EANO87B2TQ 1 0 - 6:42:02 58661 185 EANO87B2ZJ 1 1 1:00:43 2:07:27 EX27166 186 EANO87B2ZJ 1 0 - 0:00:47 EX27121 188 EANO87B4DV 1 1 13:56:37 3:02:02 61168 187 EANO87B4DV 2 1 3:47:51 0:33:03 61168 170 EANO87B4DV 3 0 - 1:44:27 61168 171 EANO87B4GQ 1 0 - 1:13:08 56728 172 EANO87B4P6 1 1 1:37:25 1:20:26 61168 173 EANO87B4P6 1 0 - 1:27:15 56728 174 EANO87B4PG 1 0 - 23:15:20 61168