Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #9: Analytics Ranking

Highlighted
6 - Meteoroid

Here is my solution!

Highlighted
8 - Asteroid

This is how I did..

Highlighted
7 - Meteor

Here is my solution:

Spoiler
Challenge_9_Solution.JPG
Highlighted
7 - Meteor

Solved.

Highlighted
7 - Meteor

this solution seems more straight forward than the official answer.

Highlighted
7 - Meteor

Good challenge!

 

Spoiler
CHerv_0-1592827817175.png

 

Highlighted
7 - Meteor

Done.

Highlighted
8 - Asteroid
Spoiler
TC_bot_1-1592863573465.png

 

Highlighted
6 - Meteoroid
Spoiler
spoiler
Highlighted
7 - Meteor

It took a couple of minutes to think about what tools I would need to figure this out. 

 

Spoiler

The Multi Row Formula was super extremely useful to solve this problem since it has access to the information in the previous row!

snaps56_0-1592856089856.png