Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start Free Trial

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

Micah_E
6 - Meteoroid

Micah_E_0-1758193472018.png

 

AlteryxUser1
8 - Asteroid
Spoiler
AlteryxUser1_0-1758732649242.png

 

icchung
8 - Asteroid
Spoiler
icchung_0-1759886752966.png

 

Short & Sweet

jrlindem
13 - Pulsar

Took inspiration from others to try and solve this without the Multi-Row Formula Tool (nor the Group By feature in the more recent version of the Record ID tool).  This challenge gets at the very useful difference between Row Numbering, Ranking, and Dense Ranking

 

Here's my solution:

 

Spoiler
jrlindem_0-1760064271083.png

 

Date:  2025.10.09

Designer:  2023.1

stevev1001
5 - Atom

Nice! And many ways to solve it.

Spoiler
SpoilerScreenshot 2025-10-10 111511.png

Ruben_Occ
7 - Meteor
Spoiler
Ruben_Occ_0-1760369490371.png

 

Garrett_Stoker
8 - Asteroid
Spoiler
Screenshot 2025-10-29 095129.png
brian_skinnell
5 - Atom

Challenge #9 - Done!

Yacs32
6 - Meteoroid
Spoiler
Yacs32_0-1763394170751.png

 

p_ng
5 - Atom

My solution.