Simple Moving Average

[Indrajeet12]

Anyone please tell me how do we calculate Simple Moving Average on perticular data of 30 days. and sample size is 3.

[Alex_Reutter]

Hi @Indrajeet12 , I would suggest looking at: https://community.dataiku.com/t5/Using-Dataiku-DSS/Using-Window-recipe-and-moving-average/m-p/10464 ?

[Indrajeet12]

Hi @Alex_Reutter ,

I just wanted to calculate simple moving avg. in below attached fashion. Please give me solution over this I tried it with window receipe but no luck.

[Alex_Reutter · Accepted solution]

Hi @Indrajeet12 , what are you trying that's not working?  Note that in the dataset you've posted, the "ID" column is not a partitioning column.  Leave the partitioning column blank in the Window recipe with this dataset.