The aggregation function is part of the definition of the KPI's performance target. The aggregation function tells the system how to merge (or Aggregate) multiple measurements over a number of periods in order to determine whether a party has passed or failed.

The are a number of ways in which multiple values can be aggregated, each producing a different result. You need to decide which type of aggregation is required to make your KPI target meaningful. The options for the aggregation functions are shown below. Fig 1 - Options for the Aggregation function

Calculation Differences for Aggregation Functions

In order to demonstrate the difference between each of the aggregation function options, the following measurements are based on a ratio KPI:

Measurement 1: 4/8
Measurement 2: 2/10
Measurement 3: 1/4

The table below shows the calculation that is performed in order to determine the aggregated value.

Tip: When dealing with Ratio Type KPI's, the most common and widely accepted aggregation function is Ratio Total

 Function Calculation Result Average ( (4/8)+(2/10)+(1/4) ) / 3 0.316 or 31.6% Count there are 3 measurements 3 Total (4/8) + (2/10) + (1/4) 0.95 or 95% Ratio Average ( (4 + 2 + 1) / 3) / ( (8 + 10 + 4) /3 )Average of the numerators divided by the average of the denominators 0.318 or 31.8% Ratio Total (4 + 2 + 1) / (8 + 10 +4 )Total of the numerators, divided by the total of the denominators 0.318 or 31.8%