Scorecard Calculations
You can use the Balanced Scorecards feature to compute the overall performance score. With scorecards, you define how metrics are weighted in comparison to each other, and scores are calculated based on these weights. Scorecards can then be displayed in a number of ways, depending on use and preference.
It's important to understand how scorecards are calculated before you create them. There are two types of scores calculated for a scorecard: weighted scores and a balanced overall score. This section explains how these score types are calculated.
A weighted score is calculated for each KPIAn acronym for Key Performance Indicator - a measurable value that demonstrates how effectively a company is achieving key business objectives., guided by these values:
- Actual Metric Value — Actual value recorded. Depending on the metricCalculates a measure for the various intervals of time and various roll-up combinations. The formula to create a metric is: a measure plus the keys for “what” and “when.”, it may be an absolute number (like number of calls handled) or a percentage (such as a QA score).
- Metric Weight — Weighting is required for each KPI. It represents the relative importance of the metric against the other metrics used on the scorecard, expressed as a percentage. The total for all metrics in the scorecard must equal 100%.
- Worst Case and Best Case Values — Used to create a floor and ceiling range for a metric. This is optional; if left blank, the system infers these values.
The weighted score is computed based on where the value is positioned in the range. By setting these values, you are configuring the range that constrains the value used in the weighted score calculation. This can sometimes help to minimize the impact of extreme values (“outliers”) and ensure that a bad or exceptional performance on one metric doesn’t affect the computation of scores for the other metrics on the scorecard. It also enables you to set baselines for metrics (where it makes sense to do so). For example, for a metric such as Average Evaluation Score, you may want to set an acceptable minimum evaluation performance level on a scorecard to 65%.
If the actual value is greater than the best case value, then best case is used in the calculation. If the actual value is less than the worst case value, then worst case is used in the calculation.
As shown in the preceding image, the base formula used to calculate the weighted score is:
((Worst Case – Actual Metric Value) / (Worst Case – Best Case)) * Weighting
Changing these values will change how the score is computed on the scorecard. For most situations, you only need to set the weight for each KPI.