community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

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

Comet

a simple solution for this one :)

Meteoroid

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

 

 

Spoiler
Capture.JPG

 

Asteroid

Done

 

Spoiler

 

122.JPG

 

Alteryx Partner

My Solution!

Asteroid

solution

 

Spoiler
Screen Shot 2018-06-25 at 10.25.35 AM.png
Bolide
Bolide

Love seeing all the participation in the weekly challenges!

Alteryx Certified Partner
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
Quasar

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

 

workflow.PNG

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

More of the usual I guess.