Skip to main content
Question

Utilization Rate

  • January 15, 2020
  • 0 replies
  • 24 views
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
------------------------------
This topic has been closed for replies.

I haven't done this personally, but probably the easiest way to do this is to create summary fields, to get the calculations, and then have those set to a report.

------------------------------
Ryan Stanford
------------------------------
Terms & ConditionsAccessibility statement