Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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

danielhoge
8 - Asteroid
Spoiler
Screenshot 2023-08-03 093708.png
tdiipo
7 - Meteor

Completed

 

 

Spoiler
Screenshot.png
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

My solution.

Spoiler
Workflow
Challenge_9_1.png
Multi-Row Formula
Rank = 
  IF [Row-1:count] != [count]
  THEN [Row-1:Rank] + 1
  ELSE [Row-1:Rank]
  ENDIF
RMiniscalco
6 - Meteoroid

Learned another new tool! (Tile)

kmbassett01
8 - Asteroid

Quick and fun - also did a second workflow to show how it would look if  you skipped a rank when it was occupied by more than one person - i.e. two people tied for 1st, and then the next person is in 3rd not 2nd.

anabelvelazque
8 - Asteroid

Hi! Here is my take :-)

HannahLaughton
8 - Asteroid

See attached solution! 

rtshow
6 - Meteoroid
Spoiler
Solution 
 

2023-08-15 14_35_43-.jpg

 

 

aaenugu
6 - Meteoroid

Came up with one solution, but when i saw the comments i found another way to do it thankyou @mceleavy

 

CASaiRam
7 - Meteor

Solution