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.
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

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

8 - Asteroid

Ok, I struggled with this one a good bit...  Definitely have a weakness when it comes to the summary tools... 😞

I had the right idea from the start, but struggled with how to make it more 'change' proof until I looked at some of the suggestions here.

I also didn't leave the format in the columns like the solution did.  I felt that that version was difficult to read and definitely would not of been good for putting into sort of visualization software

8 - Asteroid

Going back to do some old challenges that I haven't completed yet.  Not sure I understand the logic behind this one.  Don't know what I would ever do it like this, but ended up needing to copy some things from the solution because I couldn't quite get it right after about 10 different tries.

Spoiler

8 - Asteroid

Challenge 3 complete

8 - Asteroid
Spoiler
Good practice of the multirow formula tool and practice with Transpose / Crosstab. Thanks!
6 - Meteoroid

I used the multirow formula to get the moving average for 3 and 6 months.

The challenge is oddly presented, also the averages in the explanation are calculated in a really weird way, not sure how would this apply on a real world basis.

The way I understood it was a way to learn more from Transpose and Multirow formulas.

7 - Meteor

Solution

Spoiler

8 - Asteroid
Spoiler

Here is my submission, slightly different on 6 months running average, I think the solution for 6 months running average is not correct because it didn't group by Name in the multi-row formula tool. also nice to learn to set values of the closest valid row in the multi-row formula tool.

8 - Asteroid
Spoiler

7 - Meteor

done

Spoiler

Alteryx
Spoiler

I had the right idea with this one, but executed it poorly. I had the Transpose and Multi-Row Formula tools the wrong way around, and so the way to proceed would have been 12 different Multi-Row tools, at which point I gave up.

1/5