Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
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

JohnPo
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
NicoleJohnson
14 - Magnetar
14 - Magnetar

Happy Monday morning!! My solution 🙂

 

Spoiler
WeeklyChallenge122.JPG

Cheers,

NJ

patrick_digan
16 - Nebula
16 - Nebula
Spoiler
Capture.PNG
LordNeilLord
15 - Aurora

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

 

Spoiler
122.PNG

 

EstherB47
14 - Magnetar
14 - Magnetar

Same approach as @patrick_digan and @NicoleJohnson!

Prab
7 - Meteor

Solution attached.

 

 

Kenda
14 - Magnetar
14 - Magnetar
Spoiler
122.PNG
jakevanhecke
6 - Meteoroid
Spoiler
image.png

 

 

jvansisine
8 - Asteroid

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

neilgallen
12 - Quasar

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

 

Spoiler
solution 122.PNG