Forum Discussion

NathanAllan4's avatar
NathanAllan4
Qrew Cadet
6 years ago

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
------------------------------
reports and charts
  • RyanStanford1's avatar
    RyanStanford1
    Qrew Captain
    6 years ago
    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
    ------------------------------
    • NathanAllan4's avatar
      NathanAllan4
      Qrew Cadet
      6 years ago
      Ya, that's not a bad idea. I've got a summary table that sums up my duration field, which is in days, and groups them by task start date month. Problem is, one crew could potentially work on 2 or 3 tasks on the same day if they're small. So my summary table is telling me that counts as 3 days when it really only counts for 1. How can you discern that yes they worked on the 10th for example, but no they didn't work on the 14th.

      ------------------------------
      Nathan Allan
      ------------------------------
      • JasonJohnson2's avatar
        JasonJohnson2
        Qrew Cadet
        6 years ago
        You will have to breakdown the duration into hours. This would allow you to sum more accurately and would also have the benefit of allowing you to see how many days were partial days of work.  You could have a field to convert the hours to days also so you can see days.

        ------------------------------
        Jason Johnson
        ------------------------------