How does the progress calculation Sum of all check-ins divided by sum of all targets in control KPI work?
Category: KPIs
Profit.co has 4 progress calculation methods for the control KPI key result type.
Why this feature?
By considering both successful and unsuccessful check-ins in the sum for progress calculation, a comprehensive overview of project advancement is provided, enabling better evaluation and identification of areas for improvement.
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 score will be calculated with QTD value.
The Progress Calculation (At most):
The progress calculation formula is,
>100, 100 + ( diff/ target sum*100)
For example, We have a Key result to "Maintain at most $1000 marketing expenses for each week".
First check-in is $800
Second check-in is $750
Sum of First check-in and second check-in = $1550
Target sum = $2000 (i.e, Sum of target value(1000 + 1000 = 2000))
Note: You have to consider all the check-in values for the calculation. Here for example we have considered only two check-in values (First & Second check-ins), hence the target sum should be calculated as (1000 + 1000 = 2000)
Difference = Target Sum - Sum of First check-in and second check-in
Therefore, Difference = 2000 -1550 = 450
Progress = 100+ (450/2000) * 100
= 100+22.5
= 122.5%
Progress = 122.5%
QTD = $1550
The Progress Calculation (At least):
The progress calculation formula is,
>100, 100 - (diff/target*100)
For example, We have a Key result to "Gather at least 100 people for a live music concert."
First check-in - 25
Second check-in - 30
Sum of First check-in and second check-in = 55
Target sum = 200 (i.e, Sum of target value(100 + 100 = 200)
Note: As we have considered only two check-in values, the target sum should be calculated as (100 + 100 = 200)
Difference = Target Sum - Sum of First check-in and second check-in
Therefore, Difference = 200-55 = 145
Progress = 100 - (145/200) * 100
= 100 - 72.5
= 28 %
Progress = 28 %
QTD = 55
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
-
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
-
How to create a KPI from the key result creation page?
Profit.co provides an option to create a new KPI on the key result creation page. Why this feature? Instead of ...Read more