3 Replies Latest reply: Sep 6, 2016 2:02 AM by Luk�? Ro?ek RSS

    Count of maximum values in KPI

    Luk�? Ro?ek

      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))

       

      Thanks for your answers...

        • Re: Count of maximum values in KPI
          Miguel Braga

          Hey there,

           

          Can you please describe better your problem? Or can you upload some sample data and/or qvf?

           

          Regards,

          MB

            • Re: Count of maximum values in KPI
              Luk�? Ro?ek

              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
                Luk�? Ro?ek

                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