Weekly Challenge

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

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

Submit Feedback
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.

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

Highlighted
Alteryx Alumni (Retired)

A solution to last week's challenge can be found here!

 

We are thrilled to present another Challenge from our “Think like a CSE” series, brought to you by our fearless team of Customer Support Engineers. Each month, the Customer Support team will ask Community members to “think like a CSE” to try to resolve a case that was inspired by real-life issues encountered by Alteryx users like you! 

 

This month we present the case of ranking ratings in descending order.  Below, we’ve provided the information that was initially available to the Customer Support Engineer who resolved the case. It’s up to you to use this information to put a solution together for yourself.

 

The Case: A User is trying to create a column of rank for an input dataset. Like the Rank function in SQL, we want to return the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks that come before the row in question. Please see the images below for an example.

Ranking dataRanking data

 

 

Your Goal:  Create a Rank column like the Rank function in SQL.

Best,
John Posada
Cloud Engineer
Highlighted
14 - Magnetar
14 - Magnetar

Happy Monday morning!! My solution 🙂

 

Spoiler
WeeklyChallenge122.JPG

Cheers,

NJ

Highlighted
16 - Nebula
16 - Nebula
Spoiler
Capture.PNG
Highlighted
Alteryx Certified Partner

I was trying to be clever and do this in one tool but I failed and resorted to using 2

 

Spoiler
122.PNG

 

Highlighted
14 - Magnetar
14 - Magnetar

Same approach as @patrick_digan and @NicoleJohnson!

Highlighted
7 - Meteor

Solution attached.

 

 

Highlighted
14 - Magnetar
14 - Magnetar
Spoiler
122.PNG
Highlighted
Alteryx Certified Partner
Spoiler
image.png

 

 

Highlighted
Alteryx Certified Partner

Here's my approach.  Interested to see how others approach it.

Highlighted
12 - Quasar

Pretty straightforward. I couldn't help but ensure a sort before starting..

 

Spoiler
solution 122.PNG