community
cancel
Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

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

My solution is the same as most of the others!

 

Spoiler
Capture.PNG
Asteroid

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

Highlighted
Alteryx Certified Partner

My solution...

 

Spoiler
Challenge 122 - Capture.PNG
Alteryx Partner

My solution attached.

Nebula
Nebula

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

My solution:

Spoiler
challenge 122.jpg
Pulsar
 
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

 

 

 

Nebula
Nebula

Nice and easy to finish off the week

Spoiler
solution 122.png

 

Dan

Alteryx Certified Partner
Alteryx Certified Partner

Challenge Completed