Good day all you awesome people!
Have one that has my mind cracking:
Lets say we have John and Pete, and they both opened 300 and 400 files respectively for the month, giving them a nice healthy 350 files per person. Woohoo!
Now along comes Paul, opens a meager 1 file for the month, which makes it 3 people for 701 files. The average of this works out to be 233.67, which brings the KPIs for the other two guys down tremendously!
What I would like to achieve is some sort of weighted average (if possible), which gives a much more accurate answer (closer to 350 files per person).
The amount of people and files per month can vary, so this calculation needs to be super flexible.
Now lets all put the thinking caps on!
Thank you!!
Kind regards,
J
Bookmarks