Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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.