This content has been marked as final. Show 2 replies
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.