% Meeting Target Weekly

[danieldors]

Hello,

Im trying to get the percentage of employees meeting the target of 18 per day using weekly data.

Expression to determine the avg for the week:

(Sum([Drivers Total]))
/
((((Count({<[Drivers Total]={">1"}>}distinct (Date))))))

Below is the expression for the daily data which works fine:

((Sum(Aggr(If
(sum({<[Work Type]={'Generic}>} [Previous Day.Drivers Total]> 17),1),[Worker ID])))
/
count({<[Work Type]={'Generic}>}distinct [Worker ID]))

Thank you

[Andrea_Bertazzo · Accepted solution]

Hi Danieldors,

Thanks for the question. In order to calculate the percentage of the employees meeting the target, I would calculate the number of employees meeting it, divide this by the number of employees and then multiply by 100.

If I understand correctly, the target is that the value of [DriversTotal] is greater than 17. I assume the employees are under [Worker ID].

So I would use a formula like this:

(Count({$< [Worker ID] = {"=Sum( [DriversTotal])>17"}>} [Worker ID])/Count( [Worker ID]))*100

The modifier {$< [Worker ID] = {"=Sum([DriversTotal])>17"}>} is there to select only the employees who have at least 18 DriversTotal.

I hope this helps.