How do I calculate the Average/Sum cumulative value for the Control KPI Key Result?
Category: KPIs
Profit.co has progress calculation methods for the control KPI key results. Average of all check-ins divided by the average of targets & Sum of all check-ins divided by the sum of all targets
Why this feature?
By using this feature the key result can be progressed based on the check-in value’s Average/Sum of the target and the cumulative value of all check-ins, The calculation will be displayed in the slider bubble as QTD/ YTD value.
Average of all check-ins divided by average of targets
In this type of progression, the average of all the check-ins will be taken into consideration whether the check-in is successful or unsuccessful. The Progress will happen and the final calculation will be based on the average.
Additionally based on the target date we have QTD/YTD value in the check-in slider. If the key result is in the Quarter period, It will be mentioned as QTD. If it is an Annual period, It will be mentioned as YTD.
The Average of all the check-ins will be taken as QTD/ YTD value in the check-in slider.
Then the progress achievement score will be calculated with QTD value based on the below formula for progress calculation:
The progress Calculation formula is,
>100, 100+(diff/target*100)
For example, We have a Key result to Maintain at most $1000 marketing expenses for each week
First check-in 800
Second check-in 750
Average = 775
Here 1000 is Average of Target value(1000+ 1000)/2
Difference = 1000-775 = 225
Progress = 100+ 225/1000 = 100+22.5 =122.5%
Progress = 122.5%
QTD = $775
Sum of all check-ins divided by sum of all targets.
In this type of progression, An unsuccessful check-in will also be taken into account and the progress will be shown in the Sum. The sum of all the check-ins will be taken into consideration whether the check-in is successful or unsuccessful.
The Sum of all the check-ins will be taken as QTD/ YTD value in the check-in slider.
Progress achievement scores will be calculated with the QTD value.
The progress calculation formula
>100, 100+(diff/target*100)
For example, We have a Key result to Maintain at most $1000 marketing expenses for each week
First check-in 800
Second check-in 750
Sum = 1550
Target sum =2000
Here Target value is 2000 i.e, Sum of target value(2 x 1000)
Difference = 2000-1550 = 450
Progress = 100+ 450/2000 = 100+22.5 =122.5%
Progress = 122.5%
QTD = 1550
Related answer post:
To learn more about how Control KPI works on successful and distance from check-in work click here
Related Questions
-
What is Aggregation Level?
Aggregation level allows you to define the depth of aggregation. There are 2 levels available to choose from: Aggregate from entire tree of contributing OKRs Aggregate from only the next level of contributing OKRs ...Read more
-
What is KPI Extension?
While KPI aggregation works for the same KPI, KPI Extension can get aggregated value up to the extended KPI from ...Read more
-
How do you authorize the connector in salesforce?
Profit.co provides an option to enable the connector that helps users to access Salesforce. Users can create, edit and ...Read more
-
How to create a KPI and connect it with a Key Result via a connector?
Profit.co provides an option to create a new KPI and connect it with a Key Result via a connector to automate the key ...Read more
Execute your strategy with the industry’s most preferred and intuitive software
30 Days Free Trial