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

my solution

Ed2000
Asteroide
Spoiler
Ed2000_0-1675076384008.png

 

JimmyMcGrath
Átomo

Second Challenge of the day

AlexSm
Meteoro
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
Átomo

My second challenge

Goggy
Meteoroide

This is how I did Challenge 9!

 

 

Goggy_1-1675091314396.png

 

 

 

Shubham_Gulati
Meteoro

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
Bólido
Spoiler
gaoa_0-1675312098687.png

 

Wasim7568
Meteoro

Challenge #9: Solution