The KPI Value Calculation Methods are displayed on the KPI Configuration page. These methods impact the way values are calculated on the KPI Chart. Currently, there are 4 KPI Value Calculations Methods used by WiredUp: Average Value in Period, Last Value in Period, Sum of Period and Weighted Average
To explain these calculation methods, consider the example below:
The values for the month of January are captured as follows, with a default baseline of 100 and default target of 200
For this example, the Performance Period is set as Last Month. The Performance Period is the period used to determine whether the KPI is performing as expected. This Performance Period is configured on the KPI Configuration.
For each of the Calculation Methods, the KPI Chart values will be calculated as follows:
- Average Value in Period: will add all the values and divide by the count of values
- 1Quartely Jan - Mar: (100 + 100 + 100 + 200) / 4 = 125
- 2Monthly Jan 2025: (100 + 100 + 100 + 200) / 4 = 125
- 3Weekly 31 Dec - 06 Jan: 100 + 100 + 100 + 200) / 4 = 125
- 4Daily 01 Jan - 06 Jan: as captured on the KPI Values section - Last Value in Period: returns the latest value
- 1Quartely Jan - Mar: 200
- 2Monthly Jan 2025: 200
- 3Weekly 31 Dec - 06 Jan: 200
- 4Daily 01 Jan - 06 Jan: as captured on the KPI Values section - Sum of Period: calculates the sum of all the values
- 1Quartely Jan - Mar: 100 + 100 + 100 + 200 = 500
- 2Monthly Jan 2025: 100 + 100 + 100 + 200 = 500
- 3Weekly 31 Dec - 06 Jan: 100 + 100 + 100 + 200 = 500
- 4Daily 01 Jan - 06 Jan: as captured on the KPI Values section - Weighted Average: calculates the weighted average of all the values. For this method, you will need to link another KPI that will be used for the calculation.
Values from the linked KPI (which we will refer to as KPI 2):
KPI Chart:
Quarterly, Monthly and Weekly:
- Sum of the product values from KPI 1:
(100 * 10)
+
(100 * 10)
+
(100 * 10)
+
(100 * 10)
=
7000
- Sum of the values in KPI 2:
10 + 10 + 10 + 20 = 50
- Weighted Average = 7000 / 50 = 140
Daily: as captured on KPI values