We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.
alteryx Community

# Weekly Challenges

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

7 - Meteor

Good Solution

7 - Meteor

Solution with Multi Row Tools

8 - Asteroid

Good Exercise for new tools! Thank you!

Alteryx

Attaching my solution

6 - Meteoroid

Completed.

Spoiler

8 - Asteroid

To be honest I was a little confused by the formulation of the question and the form of the giving solution.

Also running the challenge took a long time, but I fixed it with putting the given solution table into a container and switching it off.

Spoiler

8 - Asteroid

Not 100%, but I couldn't find out why the multi-row formula tool doesn't perform as it seems to be expected from the challenge. Maybe something changed since then? AMP? Does anyone know? On the answer, when the original value was 'null', the tool seems to be taking the closest valid value. Note, this is different than setting the "Values for ROWS that don't exist". Anyway.

Spoiler

10 - Fireball
Spoiler
I was struggling with this for a minute. At first, was using tiling to separate the categories and names. Realized I just had to group by RM and category and then it worked as intended. Was also trying to create logic for the multirow but I see that the closest values option allows me to divide everything by six and three. Output looks different than the challenge output but their output didn't make sense to me and wouldn't be good for analyzing the data.

Tough challenge for me but good practice for one particular tool. (Details in spoiler)

10 - Fireball
Spoiler

A nice challenge, thank you, @GeneR .  I did use 'Avg' instead of Sum though in the final Transpose tool to get running avg.  Hope this is correct.  Thank you.