Finding the Moving Average of a Data Series

[TrishaSeliya]

Hi Again!

I am looking to calculate the moving average of a data series (e.g. MA 7 days). Is it possible to do this by going to the Data Manager tab > Calculated Field > Creating an Expression for the moving average?

Or do I need to write a script? I assume that's under Data Manager > Data Load Editor.

Thanks in advance for any advice!

[MayilVahanan]

Hi @TrishaSeliya 

Write in the expression tab like below

sum({<DATE = {">=$(=Date(Max(DATE)-6,'YourDateFormat'))<=$(=Date(Max(DATE),'YourDateFormat')"}>} Sales) / 7

Change the Date field based on ur date