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 #122: Think Like a CSE...Ranking Data

kelly_gilbert
13 - Pulsar

My solution is the same as most of the others!

 

Spoiler
Capture.PNG
Calliecobbs
8 - Asteroid

My solution is attached - seems to be pretty similar to most people :)

PhilipMannering
16 - Nebula
16 - Nebula

My solution...

 

Spoiler
Challenge 122 - Capture.PNG
jezknee
7 - Meteor

My solution attached.

SeanAdams
17 - Castor
17 - Castor

Very similar to all the other solutions posted above.

 

 

 

Spoiler

- Added a record ID called MTRank
- Then a multi-row formula that checked if the current row has the same rating as the prev, then set the ranking to be the same.

2018-08-05_10-55-43.png

 

Wouter
8 - Asteroid

My solution:

Spoiler
challenge 122.jpg
DavidP
17 - Castor
17 - Castor
 
jamielaird
14 - Magnetar

Trickier than I expected.

 

(EDIT: looking at all the elegant two tool solutions I clearly made this more complicated than I needed to..!)

 

(EDIT 2: leaving this here for posterity... what was I thinking? 😂)

 

Here's my solution.

 

Spoiler
122_JL.png

 

 

 

danilang
19 - Altair
19 - Altair

Nice and easy to finish off the week

Spoiler
solution 122.png

 

Dan

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed