1 Reply Latest reply on Feb 28, 2016 4:46 PM by Shinichiro Murakami

    Running Average Turn Around Time

    Jagjit Singh

      Hi All,

       

      I'm trying to get the running average on a calculated field (Turn Around Time) as I'm not getting the quick table calculation option. Could you please let me know how i can get the running average?

       

       

      Thanks

      Jag

        • 1. Re: Running Average Turn Around Time
          Shinichiro Murakami

          TRT is already using table calculation and you can not use Runing_sum.

           

          Then my approach is using this worksheet as new datasource.

           

           

           

           

          Edit new datasource

           

          add filter to filter out "Null" from this new datasource.

           

           

          Now as second datasource you get TRT as "simple value" not table calculation.

           

          [Running_sum]

          RUNNING_SUM(SUM([Turn Around Time]))

          [Count Prop]

          count([Start Date])

           

          [RUNNING_SUM(count)]

          RUNNING_SUM([Count Prop])-1

           

          [Running_AVG]

          [Running_sum]/[RUNNING_SUM(count)]

           

           

          Thanks,

          Shin

           

          9.2 attached