Hi
I have a CPI metric which starts from FY2022-23 and goes on till FY 2121-22. I want to create a rolling average of first 25 values starting from FY2022-23 including FY2022-23 plus next 24 years.
Then when it comes to FY2023-24, it does the same thing and include FY2023-24 and the next 24 years. and goes on and on.
Thanks
Musab
Best answer by Benoit
Hi Musab,
The moving average function includes an offset that could either look into past or future values.
MOVINGAVERAGE(Input, Window Size , End Offset , Dimension)
End Offset - is the offset of the last item within the window relative to current one. This argument defaults to zero, meaning the window includes all items from Window Size - 1 to current one. Default: 0.For example, if you wish to see the moving formula for 12 items into the future on a 3 items span, your formula should have this parameter included movingaverage(metric, 3, 12)
I made a quick example that can help you visualize the outputs:
Hope it helps!
Best,
Benoit
+7Hi
Accourding to me, by MovingAverage Function you can achieve your requirement. Link of that function is given below.
Thanks
Hi
Thanks
Musab
+15Hi Musab,
The moving average function includes an offset that could either look into past or future values.
MOVINGAVERAGE(Input, Window Size , End Offset , Dimension)
End Offset - is the offset of the last item within the window relative to current one. This argument defaults to zero, meaning the window includes all items from Window Size - 1 to current one. Default: 0.For example, if you wish to see the moving formula for 12 items into the future on a 3 items span, your formula should have this parameter included movingaverage(metric, 3, 12)
I made a quick example that can help you visualize the outputs:
Hope it helps!
Best,
Benoit
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.