A KPI's status and score are determined by comparing its actual value against the thresholds that you define. The performance status of a KPI is represented by the status icon that you assign to each range.
For example, for a product sales KPI in which high values are desirable, you can define the ranges that are described in Table 11-1. Thresholds are the numeric values that separate the ranges.
Table 11-1 Sample Evaluation
Evaluation Range Rule | Threshold | Name | Status Icon |
---|---|---|---|
Values exceeding 125 (125 < x) indicate ideal performance |
126 and above |
Ideal |
Blue square |
Values between 100 and 125 (100 < x <= 125) indicate good performance |
125 |
Good |
Green square |
Values between 80 and 100 (80 < x <= 100) indicate acceptable performance |
100 |
Acceptable |
Yellow square |
Values between 50 and 80 (50 < x < = 80) indicate a warning of poor performance |
80 |
Warning |
Light red square |
Values less than 50 (x <= 50) indicate critical performance |
50 and below |
Critical |
Dark red square |