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.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

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

Asteroid

My solution

 

Spoiler
challenge 122 solution Eleonora Nazander.JPG
Asteroid
 
Alteryx
Alteryx

Short and Sweet

Alteryx
Alteryx

This one went pretty quickly. The actual ranking only needed two tools. I added a bit to generalize the solution in case the items didn't come in sorted.

Spoiler
challenge_122_TonyA.png
Spoiler
Challenge_122.png
Comet

My solution.

Spoiler
Workflow 122.GIF

 

Highlighted
Meteor
Spoiler
challenge122.PNG
Meteor

I used Record ID and then a multirow formula. Ended up with the same results! 

Asteroid

Nice use of a multi row formula tool, along with a record ID to get the number of rows up until that point.

Meteoroid

Always fun to try to do it with fewer tools