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.
Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!

Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

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

Submit Feedback

Challenge #122: Think Like a CSE...Ranking Data

Ladarthure
14 - Magnetar
14 - Magnetar

a simple solution for this one :)

Laabsky
6 - Meteoroid

At first I was a little stymied, but then I got it in 3 tools.

 

 

Spoiler
Capture.JPG

 

kcgreen
8 - Asteroid

Done

 

Spoiler

 

122.JPG

 

svenk
8 - Asteroid

My Solution!

bdaniels
8 - Asteroid

solution

 

Spoiler
Screen Shot 2018-06-25 at 10.25.35 AM.png
ggruccio
ACE Emeritus
ACE Emeritus

Love seeing all the participation in the weekly challenges!

ckings
7 - Meteor
Spoiler
I really struggle with the multi-row tool so this was a great challenge! Two tools but took a long time to get my multi row to work though.
wk122.PNG
ponraj
13 - Pulsar

was able to produce the desired results using record ID and Multi row formula tool. 

 

workflow.PNG

dlrustvold
5 - Atom

My first posted solution (last week's is still too much of a mess).  I went with a summary tool rather than a multi-line formula, and did some superfluous data prep to be robust to a general input.

 

L

SnehaMatte
5 - Atom

More of the usual I guess.