In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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
12 - Quasar

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.