We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #3: Running Averages

ARussell34
8 - Asteroid

I'm not proud to say I had to look at so many other community replies to figure out these calculations.

dheissner
Alteryx
Alteryx

Why not 12 multi-row formulas ! ? But it's done.

 

Spoiler
dheissner_0-1630538527751.png

 

jenner85
8 - Asteroid

solution attached

MatthewBr
Alteryx
Alteryx

Love challenging my use of Multi-Row Tool.

Harrylosborne
8 - Asteroid
Spoiler
Harrylosborne_0-1631286964603.png

Multi-Row Formula's "Set to values of the closest row" is a great feature, ideal for doing moving averages like this.

bryonmiller
6 - Meteoroid

Solution attached. Looks like the solution key requires an update to the Multi-Row Tool to have the 6-mo rolling average group by RM Category.

Spoiler
bryonmiller_0-1631742076268.png

 

quantumudit
6 - Meteoroid

Here goes my solution for challenge-3:

 

Spoiler
Spoiler

quantumudit_0-1632064967538.png

 

I think the output solution provided here is not correct. Its mixing everything in the "Name" column and not practical too.

Please review my solution and let me know if that is correct or, do I need to take some other route..

 

Thanks

Normster
8 - Asteroid

This is a repost.  I went back and looked at some of my earlier attempts.  

 

This time around I have different answers because I didn't use the impute tool; I calculated values based on monthly averages. I think this gives a more accurate picture.  I also had more steps because I renamed fields.

Spoiler
Normster_0-1632157841146.png

 

Debbie_N
Alteryx
Alteryx

 

Solution Attached

 

Spoiler
Challenge 3.png

 

manisha0506
6 - Meteoroid

Here's my take on the challenge