Challenge #3: Running Averages

[JXEC]

You know, there's a couple of small errors in terms of what's written. Mostly the examples and P.1K being D.1K in the provided set.

Regardless, here's my solution.

[Tony_Castillo]

Spoiler

[nisa_m]

Challenge done...

[Ollie_M]

This is my solution. Output format is different but the values are still accurate. Personally I think this is a superior output format. 

Spoiler

[JesusER]

My solution!!! 

Spoiler

[dbmurray]

Can't say I was super into this challenge (I guess the data was somewhat meaningless and difficult to understand what it represented). However solved - exactly like the posted solution it turned out. 

Spoiler

[matthewblandford]

I believe this is technically correct...I think the target output has incorrect data...it appears that the 6-month rolling averages are incorrect once you change RM Categories (I looked at the proposed solution after creating mine, and it looks like the Multi-Row Formula doesn't group by RM Category on the 6-mo average, even though you should). Regardless, I believe this is what they were going for!

[Daniel_Griffith]

Done!

Manually created 5 months of past data (same info as 1st month) - didn't realise the multi-row tool would use the top row of data when asked to return something from a negative row.

Different output format, but the same info.

[MichaelPilotFreight]

Check out my solution!

[jenner85]

Alteryx freezes every time I open this workflow - anyone else having this issue?