Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThis is my solution. Output format is different but the values are still accurate. Personally I think this is a superior output format.
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.
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!
Alteryx freezes every time I open this workflow - anyone else having this issue?