We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. 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

LindaLo
8 - Asteroid

I used multi row formula 

and its also interesting to see another solution from you

 

aanandkumar
8 - Asteroid
 
JonKennah
6 - Meteoroid
Spoiler
Spolier 9.PNG
Desmond
8 - Asteroid

The challenge asks that you rank similar to golf rankings.  If this were the case then if two people were tied for 1st then there would be no ranking of 2nd, it would then go to 3rd and so on.  I was able to get to the answer but the workflow would need to be adjusted slightly to get to an answer that is truly like a golf rank.  Still a fun and quick challenge.

Bhavna
5 - Atom

@BenMoss Defo prefer your solution!

 

But if you only wanted to keep the top 5 people, how would you do it?

 

The Sample tool wouldn't work as it would only allow you to keep the first 5 rows (and therefore, only keep those ranked 1-3).

black28
7 - Meteor
Spoiler
Solution
Siobhan_Purcell
8 - Asteroid
Spoiler
Siobhan_Purcell_0-1581246883423.png

A little bit of a tricky one, but here's my solution for challenge #9!

garymitter
5 - Atom

Have solved, my first weekly challenge solution.

smitapote
6 - Meteoroid

Challenge 9 Solution attached

Igor_Garlowski
7 - Meteor