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

Jagruthi
6 - Meteoroid

Jagruthi_0-1611085060884.png

 

Elena_Efrim
6 - Meteoroid

Solution for Weekly Challenge #9

SimonEvans
8 - Asteroid

My solution:

 

Sorted by count descending, then used the multi-row tool to assign the rank, then filtered to rank 5 or less

 

Weekly Challenge #9.png

PatForData
8 - Asteroid

Solution Attached

 

Iroshan464
6 - Meteoroid

0.6 seconds.

 

Emily_P
8 - Asteroid

Done!

annaprosvetova
7 - Meteor

Solution is below

Spoiler
annaprosvetova_0-1611652848911.png

 

sonnenthaler
6 - Meteoroid

Nice Challenge. I've never used the Multi-Row Formula Tool before, so it was a good learning experience.

I did not know how to start from 1 (and not from 0), so I added a Formula Tool afterwards.

Spoiler
sonnenthaler_0-1611829467103.png

 

mrodriguez1
7 - Meteor
Spoiler
mrodriguez1_0-1611832815494.png

 

jdbartosh
8 - Asteroid

Solution has been uploaded