Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
alteryx Community

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.

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

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 data

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

Best,
Cloud Engineer
ACE Emeritus

Happy Monday morning!! My solution :)

Spoiler

Cheers,

NJ

17 - Castor
Spoiler
15 - Aurora

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

Spoiler

15 - Aurora

Same approach as @patrick_digan and @NicoleJohnson!

7 - Meteor

Solution attached.

16 - Nebula
Spoiler
6 - Meteoroid
Spoiler

9 - Comet

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

12 - Quasar

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

Spoiler