I have a table with objectives and key results attached to related objectives.
|Achieve 1M $ in EMEA sales||Marketing||50%|
|Demo and Tests||40%|
Im formatting a pivot table and with avg(percentage) calculation, i can find average percentage of an objective, in this case for Achieve 1M$ in EMEA sales is 36,25
I need to count objectives with a %100 percentage as a KPI Item but i couldnt figure.
So i decided to create a calculated dimension. I called it 'Status' and as a formula i wrote : if(avg([percentage]='1','Done','In Progress') But it didnt work.
What can cause that?
I calculated grand average with : avg(aggr(avg(Percentage),Objective))
What i need to do is to count how many objectives have %100 percentage.
Grand average is the average of all objectives. With your formula im finding another result which is not correct.
But my main goal is to count %100 objectives as i mentioned earlier. And i cant understand why im keep failing.
Ok, sorry for the language. Here is a detailed example:
Objective Key Result Percentage
Verimliligin arttirilmasi Aylik depo sayimlarinin yapilmasi ve raporlanmasi Production 30.06.2017 90%
Verimliligin arttirilmasi Kritik ve atil stok calismasinin tamamlanmasi Production 30.06.2017 95%
Verimliligin arttirilmasi Personel egitimlerinin tamamlanmasi Production 30.06.2017 90%
Verimliligin arttirilmasi Merkez uretim alaninin belirlenmesi Production 30.06.2017 15%
In this example, objective so called 'Verimliligin arttirilmasi' has 4 key result and each one of them has a percentage. And from these percentages(90%,95%,90%,15%), there is an average for related objective(72.5%)
I have a long table with entries like that.
So know i want to add a KPI item which counts objective with avg(percentage) of 100%