Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Difference Between Check Mark and Exclamation in KPI Card

I'm about to release a new dashboard for my organization and I know this question is coming. What is the difference between the '!' and the Checkmark in the KPI Visual? Thank you for your help.

 

Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    7 years ago

    The check mark means the KPI is better than the goal (higher if high is good, lower if low is good).  The exclamation means the KPS is worse than the goal (lower if high is good, higher if low is good).

     

    Your first KPI low is good and 1.22 is < 1.35 so it gets √
    The second KPI high is good and 96% < 100% so it gets !

3 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Icon for Super User rankSuper User
    7 years ago

    The check mark means the KPI is better than the goal (higher if high is good, lower if low is good).  The exclamation means the KPS is worse than the goal (lower if high is good, higher if low is good).

     

    Your first KPI low is good and 1.22 is < 1.35 so it gets √
    The second KPI high is good and 96% < 100% so it gets !

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thank you jdbuchanan. That is correct.

       

      It comes down to the color coding section of editing your kpi card.

       

      My next challenge is having a goal that is a range of values.  For the 96% example above, it's actually within the range, as we're looking for 100+-5%.

       

      • jdbuchanan71's avatar
        jdbuchanan71
        Icon for Super User rankSuper User
        7 years ago

        If you adjust the goal a bit and use the absolute of the calc it should work.

         

        Measure = 1 - ABS ( 1 - [Actual FTE vs Budget] )

        Goal = .95
        Higher is better

        In your example Measure would return .96 which is higer than .95 so it would be good. 

        If the [Actual FTE vs Budget] was say 103%

        1-1.03 = -.03

        ABS (-.03) = .03

        1-.03 = .97

        .97 > .95 so that would also be good.