4 Replies Latest reply on Oct 15, 2018 2:00 PM by Andrew M

    Moving Weighted Average

    Andrew M

      Hi all,

       

      I'm trying to dynamically calculate a moving weighted average and was hoping for some help. I found a few similar posts but couldn't find a solution that would work with drilling down or rolling up.

       

      I'm attaching a blank twbx and sample data. I'd like to show the moving average of Processing Time, weighted by Actions. I'd like the calculation to update based on the data displayed on the view. For example, if 4 quarters were displayed, the moving average would be based on the 4 quarters displayed. Or, if only the current month was displayed and drilled down to show individual days, the weighted moving average would be for the current month by day.

       

      Here's an example of the desired outcome for a few days from the data set. I appreciate any help and guidance!

          

      DateActionsProcessing TimeMoving Weighted Average Processing Time*manually calculated*
      1/1/20172411
      1/2/20175521.70
      1/3/20179532.41
      1/4/20173983.43
      1/5/20172223.30