KPI Calculations - Best Practices
Best Practices on Using Calculations
· Use calculations only with Standard KPIs (non leaf level).
· Accept the default values for Standard KPIs (leaf level) and Objective KPIs.
Detailed Description of Behavior
To understand how the Calculation setting affects a KPI, it is important to understand the differences between three types of KPIs:
· Standard KPIs (leaf level) . These KPIs have no KPIs below them in the scorecard hierarchy and have the option "Use calculated values of Actual and Target to compute score" selected in the Calculation dialog box.
· Standard KPIs (non leaf level) . These KPIs have one or more KPIs below them in the scorecard hierarchy and have the option "Use calculated values of Actual and Target to compute score" selected in the Calculation dialog box.
· Objective KPIs. These KPIs have one or more KPIs below them in the scorecard hierarchy and have the option "Use calculated values of Actual and Target to compute score" cleared (not selected) in the Calculation Dialog box.
Calculation settings apply differently, depending on the type of KPI. In addition, be aware that each KPI has a value and a score. For Standard KPIs, the value is a number that either comes directly from a data source or is calculated based on child KPIs (such as the average of child KPIs). Values are not used with Objective KPIs.
For Standard KPIs, the score is a percentage that compares the KPI's Actual value to its Target value. (This percentage can be a raw score or normalized score, based on its thresholds.) For Objective KPIs, the score is the weighted average of the scores of the child KPI. The score determines which indicator is shown. (Note that you can override the score by selecting Band by Stated Score in the Edit Bandings dialog box.)
Scores are shown on a scorecard, as illustrated:
The following table explains how calculations settings affect your scorecard KPIs:
| Value Based on KPI Type | Value Based on KPI Type | Value Based on KPI Type | ||
| Calculation Setting | Standard KPI (leaf level) | Standard KPI (non leaf level) | Objective KPI | |
| Default | Score | Calculated value of Actual to Target | Calculated value of Actual to Target | Weighted average of child KPIs |
| Value | Value selected in Data Mappings | Value selected in Data Mappings | Not used | |
| No Value | Score | Set at 0% | Set at 0% | Weighted average of child KPIs |
| Value | Blank | Blank | Not used | |
| Source Data | Score | Calculated value of Actual to Target | Calculated value of Actual to Target | Weighted average of child KPIs |
| Value | Value selected in Data Mappings | Value selected in Data Mappings | Not used | |
| Average of Children | Score | Set at 0% | Calculated value of Actual to Target | Weighted average of child KPIs |
| Value | Blank | Average of child KPI values | Not used | |
| Sum of Children | Score | Set at 0% | Calculated value of Actual to Target | Weighted average of child KPIs |
| Value | Blank | Sum of child KPI values | Not used | |
| Max of Children | Score | Set at 0% | Calculated value of Actual to Target | Weighted average of child KPIs |
| Value | Blank | Highest value of child KPI values | Not used | |
| Min of Children | Score | Set at 0% | Calculated value of Actual to Target | Weighted average of child KPIs |
| Value | Blank | Lowest value of child KPI values | Not used |
Elaine Andersen (elainean@microsoft.com)