Finding the Moving Average of a Data Series

[paulbatny57]

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!

[Anil_Babu_Samineni]

I never user data manager but you can take that as resident and necessary changes since you are not able to unlock the autogenerated script. try this if you ready to use

Load Dim1, Dim2, ..., If(DateField>=Max(DateField, -7) and DateField<=Max(DateField), Avg(Measure)) as Avg_Measure7Days Resident DataManager_Directory Group By Dim1, Dim2, ...;