2 Replies Latest reply on Jun 24, 2018 10:40 PM by Deepak Rai

    Calculation Correct For One Day Period But Not Two

    Courtney Poles

      Hi,

       

      The attached workbook will correctly calculates the Team Utilization for a one day period but not two or more. For example:

       

      6/21/18:

      TeamTimeOnTask = 759

      TeamMinutesWorked (this calculation happens inside the Team Utilization calculated  field) = 4320

      Team Utilization  = .17569

       

      6/22/18:

      TeamTimeOnTask = 931

      TeamMinutesWorked = 4800

      Team Utilization  = .19395

       

      I would expect that if both 6/21 and 6/22 were selected that:

      TeamTimeOnTask = 1690

      TeamMinutesWorked = 9120

      Team Utilization  = .18530

       

      Can anyone tell what I am doing wrong? Workbook attached.

       

      Thank you!

       

      Courtney

       

      Message was edited by: Courtney Poles Added Tableau V2 workbook