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_B
Alteryx
Alteryx

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.