Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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 :)