Types of Totalization on Gestiona

There are several ways to totalize a KPI, in this article we will detail each of the functions provided by the ICG. To find out how to totalize a KPI, visit our KPI Totalization article.

 

When entering the KPI Register and going to the Totalization tab, you can select which function will totalize the KPI.

Below we will explain how each of these functions work:

• Count Yellows: it will count the number of KPIs with yellow beacons in the month. In the measurements of the KPI being totaled, the values ​​of the “Done” field will be blocked for editing. The user must register the values ​​for the Green and Customer Bands.

• Count Yellows and Reds: it will count the number of KPIs with yellow and red beacons in the month. In the measurements of the KPI being totaled, the values ​​of the “Done” field will be blocked for editing. The user must register the values ​​for the Green and Customer Bands.

• Count Yellows, Reds and Blues: it will count the number of KPIs with yellow, red and blue beacons in the month. In the measurements of the KPI being totaled, the values ​​of the “Done” field will be blocked for editing. The user must register the values ​​for the Green and Customer Bands.

• Count Red: it will count the number of KPIs with red beacons in the month. In the measurements of the KPI being totaled, the values ​​of the “Done” field will be blocked for editing. The user must register the values ​​for the Green and Customer Bands.

• Highest value: it will bring the same value of the KPI with the highest measurement (performed). In the measurements of the KPI being totaled, the values ​​of the “Done” field will be blocked for editing. The user must register the values ​​for the Green and Customer Bands.

• Average Value: it will average the measurements (performed) of the KPIs. In the measurements of the KPI being totaled, the values ​​of the “Done” field will be blocked for editing. The user must register the values ​​for the Green and Customer Bands.

• Average Value and Average of the Tracks: it will average the measurements and bands (green and customer) of the KPIs. In the measurements of the KPI being totaled, all values ​​will be blocked for editing.

• Lower value: it will bring the same value of the KPI with the smallest measurement. In the measurements of the KPI being totaled, the values ​​of the “Done” field will be blocked for editing. The user must register the values ​​for the Green and Customer Bands.
• Worst Color: it will bring the same color as the KPI with the worst beacon. In the measurements of the KPI being totaled, all values ​​will be blocked for editing. Note that no value will be brought from the totalization. If you want to register any amount, it must be done before totaling the desired KPI.
• Sum Actual and Budgeted: it will add up all the realized and budgeted values ​​of the KPIs, based on a calculation so that it is statistically correct. In the measurements of the KPI that is being totaled, the values ​​of the field “Accomplished” and “Budgeted” will be blocked for editing. The user must register the values ​​for the Green Band.Take care that the types of items are the same, otherwise there may be an error in the sum of the values.

• Adding Values: it will add up all the realized values. In the measurements of the KPI being totaled, the values ​​of the “Done” field will be blocked for editing. The user must register the values ​​for the Green and Customer Bands. Take care that the types of KPIs are the same, otherwise there may be an error in the sum of the values.

• Add Values ​​and Ranges: it will add all the values ​​of the accomplished, of the green band and of the customer band. In the measurements of the item being totaled, all values ​​will be blocked for editing. Take care that the types of KPIs are the same, otherwise there may be an error in the sum of the values.

• Adding Values ​​and Expected: it will add the values ​​of the accomplished and green band. In the measurements of the KPI being totaled, the predicted and realized values ​​will be blocked for editing. Take care that the type of KPIs are the same, otherwise there may be an error in the sum of the values.

 

IMPORTANT:

1. In the item being totalized, the predicted and actual values will be locked (with a padlock) for editing on the measurement screen;

2. For the Sum and Average functions, the items that are part of the totalization must be of the same type. See more in the KPI Registration: KPI Types article.

 

For KPIs of type 1C, the calculation of the Sum Values ​​and Bands function is different for the Green Band . See below how the calculation is done:

 

1. Calculates the difference between the bands;
2. Square the difference;
3. Add the squares of the KPIs;
4. Make the square root of the sum of the squares;
5. Make the Green Band Average;
6. Sum the average of the KPIs;
7. The Lower Green Band is the average of the KPIs minus half the square root of the sum;
8. The Upper Green Band is the average of the KPIs plus half the square root of the sum;