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
Spoiler

6 - Meteoroid

3

8 - Asteroid
Spoiler

Here's the solution!

8 - Asteroid

A nice challenge! Help me recap the knowledge of Multi-Row Formula, Cross Tab, and Transpose Tool.

5 - Atom

The solution is confusing to me because in the multi-row formulas, the 3 month averages are calculated by grouping by "RM category" but the 3 months averages are not. So that starting record#73 where RM category becomes 100rm, the averages are still reflecting those in 10rm, which is incorrect as we need to calculate the averages by RM category. If the 6 month avg. for 100rm is calculated properly, the result should be 42 instead of 7 [(0+0+0+0+0+0+42)/6]

7 - Meteor

I didn't quite match the "target" output format but I feel like this column setup is a little more reflective of the enquiry goal...

Spoiler

5 - Atom

I mean the two multi-formula tools have inconsistent settings-one is grouped by RM category while the other is not.

8 - Asteroid
Spoiler
7 - Meteor

Solution:

8 - Asteroid

My solution attached.