Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

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.

SUBMIT YOUR IDEA

Challenge #9: Analytics Ranking

SWalker
7 - Meteor
Spoiler
Screenshot 2021-05-12 103559.png

Thomas_W
8 - Asteroid

Solution attached

Erin
9 - Comet

Below is my submission. Looking forward to checking against the posted solution! 

 

Spoiler
Challenge 9.PNG
Ridler
5 - Atom
Spoiler
Ridler_0-1621431127299.png
Jonny
11 - Bolide

my solution

ARussell34
8 - Asteroid

Here is my solution!

Mario36
8 - Asteroid

Here are my solutions, I have solved them using two approaches

Spoiler
#1 Record ID Tool
#2 Multi Row Formula
euanwilson
8 - Asteroid

4th challenge complete. 

 

Spoiler
So firstly I just used the sort tool to order the record firstly by count in descending order and then by alphabetical order to separate any people with the same count. I then used the RecordID tool to assign each player a rank based on the two parameters above. Finally I used a filter to narrow the list down to the top 12. (The questions asks for top 5 but the output shows top 12?). 

Work Flow.PNGResults.PNG
bam
7 - Meteor

.

Ywanggo
5 - Atom

There is my answer.