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

Natasha
9 - Comet

Went with my favourite multi-row formula as well

Spoiler
Screen Shot 2017-08-27 at 22.10.05.png

 

luciebrett
8 - Asteroid

Hello forum,

 

My ranking solution varies quite a bit to the proposed solution; I have used fewer tools and no join or summarise. I prefer to work with formulae however a rank tool would have made life much easier!

 

Lucie

 

 

JORGE4900
8 - Asteroid

I used two different approaches to creating the ranking system; the first way is the tile tool, and the second way is the multirow tool. Which one do you like best?

espeigle
5 - Atom

I noticed many similar methods! I'm still getting used to the multi-row formula tool, but I eventually got it to work. :) 

 

Spoiler
Capture2.PNG

 

 

 

patrick_digan
17 - Castor
17 - Castor
Spoiler
Capture.PNG
MaxGiegerich
8 - Asteroid

A similar solution to the answer compared to some of the other suggestions... Lots of options on this one!

MaxGiegerich
8 - Asteroid

I have to echo Sean Adams on this one! Same solution as @Rachel_Burge, but seems @mceleavey has the right idea with the tile tool. We live and learn...

Amarendra
10 - Fireball

Rank got me a bit but solved it using multi-row tool. 

data_rachel
8 - Asteroid
Spoiler
challenge9.PNG
hoheusle
6 - Meteoroid

My method was a little longer than the thread solution, but it works :)