2 Replies Latest reply on Oct 12, 2016 2:34 AM by Rowel Zantua

    How to calculate moving average using date range?

    Rowel Zantua

      Hi everyone!

       

      When using the function WINDOW_AVG to compute for the moving average, the second and third arguments seem to refer to the index of the rows thus (WINDOW_AVG(SUM([Value]),-3, 0)) does not mean 3 days prior instead, 3 rows prior to the current row which is 0. This is not a good reference when computing using a date range.

       

      Is there a way to compute the moving average without using a table calculation?

       

      Moving average should be computed as shown in the table below.

       

      Foregone.jpg