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.
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

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 #9: Analytics Ranking

cplewis90
13 - Pulsar
13 - Pulsar
Spoiler
It is always fun to stay in one tool palette! I want to see how others solved this!
Challenge 9.PNG
atulesheorn
6 - Meteoroid
 
nikolaskardasis
8 - Asteroid
Spoiler
Solution.PNG
atrozz
8 - Asteroid

Hello all.

I post my workflow. First, 'group by' by count and sort descending; then i add a record. Then i apply a inner join by count and filtering when Rank <= 5. Finally i sort again descending and finish with the result. I post the image with workflow and results.Challenge 9.png

rachelgibbons
8 - Asteroid

Done!

shraddha_somani
6 - Meteoroid
 
IJReed
8 - Asteroid

👍

papalow
8 - Asteroid

At the end of my work day using Alteryx....it was nice to have a simple challenge to solve.

Benbryans
8 - Asteroid

Surprised to see how different the official solution was!

alyssa_sedai
8 - Asteroid

Here is what I did