Forum Discussion

amaddala's avatar
amaddala
Icon for Helper I rankHelper I
5 years ago

Moving average with custom calendar

I need help calculating moving average of last 4 fiscal weeks in my data. We cannot use datesinperiod as I need to use "Week" in my steps. I have fiscalweek number ( for ex: 31, 32, 33 etc )  Please...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi amaddala ,

 

Based on your description, I did a test. Is the following result what you want?

 

 

Best Regards,

Yuna

amaddala's avatar
amaddala
Icon for Helper I rankHelper I
5 years ago

Yes, this is what I am looking for. How did you achieve this?