We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

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
ACE Emeritus
ACE Emeritus

Happy Monday morning!! My solution :)

 

Spoiler
WeeklyChallenge122.JPG

Cheers,

NJ

patrick_digan
17 - Castor
17 - Castor
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
15 - Aurora
15 - Aurora

Same approach as @patrick_digan and @NicoleJohnson!

Prab
7 - Meteor

Solution attached.

 

 

Kenda
16 - Nebula
16 - Nebula
Spoiler
122.PNG
jakevanhecke
6 - Meteoroid
Spoiler
image.png

 

 

jvansistine
9 - Comet

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