3 Replies Latest reply on Oct 24, 2017 4:10 PM by Deepak Rai

    Count number of Green KPI for specific Metric

    Abdul Subhan Mohammed

      Hello Fellow Data People,

       

      I am creating a scorecard, where the the hierarchy is as follows:

       

      Division -Agency 1 -Ticket 1 100

                                     -Ticket 2 25

                                     -Ticket 3 25

      .

      .

      .

       

      here the average of the ticket value is the value of the agency 1(green, yellow or red) in the division. Similar is the case for agency 2, agency 3 etc.

       

      There are 3 KPIs, Green, Yellow and Red and it is being measured on weekly basis.

       

      Now I have to count the number of greens/week in all of the 3 agencies (agency 1- Green, agency 2- Green, agency 3- yellow) and perform the calculation:

       

      Number of greens / total number of agencies, i.e as per above example 2/3 = 0.75 (75%)

       

      But i am not able to get the value since I am taking the average of tickets, hence I cannot take the aggregation of the value already aggregated.

       

      Any help would be really helpful.

       

      I have also attached sample worksheet for reference.

       

      Please help.

       

      Regards,

       

      Abdul