Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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

lapin_dangelau_24
7 - Meteor

my solution

Ed2000
8 - Asteroid
Spoiler
Ed2000_0-1675076384008.png

 

JimmyMcGrath
5 - Atom

Second Challenge of the day

AlexSm
7 - Meteor
Spoiler
 Solution to Challenge 9

AlexSm_0-1675091102914.png

Multi Row Formula:

if [Row-1:count]=[count] then [Row-1:Rank] else [Row-1:Rank]+1 endif

 

AnnaPetra
5 - Atom

My second challenge

Goggy
6 - Meteoroid

This is how I did Challenge 9!

 

 

Goggy_1-1675091314396.png

 

 

 

Shubham_Gulati
7 - Meteor

Done!

caltang
17 - Castor
17 - Castor

Solved! 

 

Would be nice if Alteryx had an in-built Rank tool. Would help heaps! 

 

Spoiler
caltang_0-1675255557316.png

 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
gaoa
11 - Bolide
Spoiler
gaoa_0-1675312098687.png

 

Wasim7568
7 - Meteor

Challenge #9: Solution