10 Replies Latest reply on Mar 23, 2016 1:13 AM by Łukasz Majewski

    Average TurnAround Time

    Jagjit Singh

      Hi,

       

      I have the attached workbook and have a calculate field called Turn Around Time. I need to create a visual to show the average turn around time but not getting the Measure option and cannot apply AVG in the formula.

       

      Any ideas how i can achieve the avg turn around time. What i have noticed is that the TRT value is dependent on the how the tenant code is sorted. If its not sorted based on the start date, the wrong values appear.

       

      Thanks

       

      Jag