Moving Average

unknown

Hi,

I have millions of data. I need to take average of last 12 records for every fields. 

for eg:-

 average of last 3 for each column.

Col1 Col2 Col3 Col4 Col5

1       2        3      5      6

2       3        4      5       6

3      4         5      6      7   

4     5         6      7

5     6         7

6     7

7

output:

Col1  Col2  col3   col4   col5

6        6        6        6        6

Every time it moves to right side average of 3 moves up too. I need to make this using alteryx.

Thanks

brindhan

Hi @Inactive User

Here you go.

Also, check out the imputation field to replace nulls, etc, might help you.

Cheers,

B

solution - Copy.yxmd