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

Asteroid

My solution is the same as most of the others!

 

Spoiler
Capture.PNG
Meteor

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

Alteryx Certified Partner

My solution...

 

Spoiler
Challenge 122 - Capture.PNG
Meteor

My solution attached.

Aurora
Aurora

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

 

Alteryx Partner

My solution:

Spoiler
challenge 122.jpg
Quasar
 
Alteryx Certified Partner

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

 

 

 

Quasar

Nice and easy to finish off the week

Spoiler
solution 122.png

 

Dan

Asteroid

Challenge Completed