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

jjlauman
6 - Meteoroid

Challenge #9 complete

Junya_Wang
8 - Asteroid

Please see attached solution

MarielJinang14
7 - Meteor
Spoiler
Challenge #9.PNG

 Here is my solution. Thanks!

steven4320555
8 - Asteroid

Simple ranking, but observed the change of order after various tools. It seems not consistent. Normally ascending order, but I have seen some random behavior.

 

Spoiler
steven4320555_0-1585851764791.png


So best use some more consistent and robust methods for ranking or ranking before final output.
(I also learnt to use the multi-row formula by browsing through some previous answers. But, the group option will change order, if used.)

 

Haroonanalytics
7 - Meteor
Spoiler
Spoiler

Challenge 9 image.PNG
I've gone back to how I would do it in excel and Multi-Row formula was a good tool to learn in the process 😉
EricaR
Alteryx
Alteryx

Solution Attached. 

kenhermosura
6 - Meteoroid

solution attached.

SilviaRox
7 - Meteor

Hi all, here's my solution

igorp
8 - Asteroid
Spoiler
igorp_0-1586512554898.png

 

grossal
15 - Aurora
15 - Aurora

Time to work on these challenges!

 

Spoiler
grossal_0-1586514484496.png

 

Not as clean as it could been, but I am fine with it.