How to calculate the average of the 12 last rows, every row again?

[DM_88]

Hi

Ho do I calculate the average of the 12 last rows, every row again?

So in this case I mean:

As you can see cell C42 is the average of B31:B42, cell C41 from B30:B41, etc.

Can I make a similar calculation in Alteryx? If yes, how does it work?

Attached you can find both documents.

Thanks a lot!

Kind regards

DM_88

[Emil_Kos · Accepted solution]

Hi @DM_88 ,

Probably there are hundreds of more efficient ways but I think my will solve your problem.

[MarqueeCrew]

Hey @DM_88 ,

I suggest that you download the CReW macros and use our moving summarize. 

http://downloads.chaosreignswithin.com/Macros.zip  

cheers,

mark

[DM_88]

Hi Emil

The only thing I needed to change in your calculation was Type to Double but your solution works perfect!

Thanks a lot.

Grtz

DM_88