Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!
alteryx Community

# 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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

## Challenge #3: Running Averages

8 - Asteroid

I am working my way through the Alteryx Challenges as I am learning Alteryx. Here is my solution to the problem.

11 - Bolide
Spoiler

8 - Asteroid

Started the workflow by transposing the data columns then I proceeded to apply the following treatments:

- sorted it ascending by RM Category, Year and Month

- Replaced Null() values with with the value on the previous row

- Used a Multi-Row Formula for creating the 3 months average, respectively the 6-month one

8 - Asteroid

Ok Terrific

8 - Asteroid
Spoiler

Seems a bit silly to put a Spoiler tag on it when the original post is 8 years old...

I didn't pivot it all back into column to match the output because that also struck me as silly.

7 - Meteor

my solution

8 - Asteroid

I got most of the way, but had to peek to get it right. 🙄

8 - Asteroid

Great use of Multi-Row formula tools.

It's weird that the problem is giving you a hint:  "For Values that do not exist, set values to closest valid row. " But the solution actually does not do that. It uses a zero for nulls instead. So I followed the hint and my response is slightly different from the solution.

I definitely learned that you can change the Num Rows in the Multi-Row Formula tool to play with a bigger selection of row, rather than the default 2.

I also used the Average( ) formula rather than adding and then dividing by 3 or 6...should do the same thing theoretically :)

I also didn't do the last transpose as I liked how my table looked better. It doesn't make sense to me to put the RM Category as a Value. What was the reason for that?

8 - Asteroid
Spoiler

15 - Aurora

Question is framed interestingly, and answer is not what is requested.

I've gone with a benefit of the doubt approach

Spoiler