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

Tberney
8 - Asteroid

Second Challenge: #9

Sort descending, assign rank, select rank<=5

Tberney_0-1589565696729.png

 

MariaDonna
6 - Meteoroid

My simple solution 🙂

DMContente
8 - Asteroid

My solution:

powell
5 - Atom

My solution

edavilac
8 - Asteroid

My solution attached.

 

Spoiler
Challenge_9_edavilac.PNG
mheinze
Alteryx
Alteryx

Used multi-row tool to calculate rank. Liked seeing Tile example also posted. 

Spoiler
mheinze_0-1589927437963.png

 

balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1589938950041.png

 

vorod
5 - Atom

Good practical application of multi-row formula. 

 

vorod_0-1590322648793.png

 

izamryan
8 - Asteroid

Piece of cake!

 

Spoiler
izamryan_0-1590347613482.png

First off, sort the data set
then add a RecordID
The trick here is to use a multi-row formula that creates the ranking, grouped by the # of count
Then we filter based on just the Top 5 ranked
And finally, a Select to clean up the data

ojnouh33
5 - Atom

 

Weekly Challenge 9.PNG