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 !

jdbuchanan71's avatar
jdbuchanan71
Super 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
      Super 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.