NathanAllan4
6 years agoQrew Cadet
Utilization Rate
I'm trying to create a KPI in Quickbase that will tell me the utilization rate for our entire crew. Basically I want every crew to have their own rate and then average that for the entire company. It would be calculated by dividing the number of working days in a month where that crew had a task assigned to them, by the total number of working days in the month.
For example Crew 1 has multiple tasks assigned to them for a total of 10 working days in January out of the possible 22 working days, giving them a 45% Utilization Rate.
I'm not sure how to exactly build this though.
Any thoughts/ideas would be super helpful!
Thanks in advance!
------------------------------
Nathan Allan
------------------------------
For example Crew 1 has multiple tasks assigned to them for a total of 10 working days in January out of the possible 22 working days, giving them a 45% Utilization Rate.
I'm not sure how to exactly build this though.
Any thoughts/ideas would be super helpful!
Thanks in advance!
------------------------------
Nathan Allan
------------------------------