2 Replies Latest reply on Jun 18, 2018 8:09 AM by Rishu Mankotia

    Calculation of Utilization percentage over a period; monthly percentage is ok but overall is incorrect

    Rishu Mankotia

      I need help in fixing the utilization calculation for over a period in tableau.

       

      I use the following calculation to get answer for my monthly utilization percentage:  zn(SUM([Billing Time])/(21*8*COUNTD([Assigned To])))

       

      The assigned to field gives me the number of resources.

       

      This gives me a correct monthly utilization percentage value but the answer is off/wrong when the filter selects overall period i.e. all months cumulative.