Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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