Hello,
It's a quite silly question, but I am still kinda not sure of their difference.
Thank you for your help!
Best regards,
Tony
2 answers
In effect, a moving average is a window_average for a moving range of marks. An example of a 6-month moving average is the average of Jan-June in the first mark, and Feb-July in the second mark, and Mar-Aug in the 3rd mark, etc. (And usually you want to display the first value in June, and the second value in July, etc...) The syntax for such a moving average would be something like this:
window_avg(sum(sales), -5, 0) // (Grab 5 months back through the current month, and do an average.)
