topic Re: Challenge #122: Think Like a CSE...Ranking Data in Weekly Challenges

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

JohnPo — Tue, 13 Sep 2022 14:16:37 GMT

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.

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

NicoleJohnson — Mon, 25 Jun 2018 15:29:51 GMT

Happy Monday morning!! My solution :)

Cheers,

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

patrick_digan — Mon, 25 Jun 2018 15:32:06 GMT

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

LordNeilLord — Mon, 25 Jun 2018 15:48:39 GMT

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

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

estherb47 — Mon, 25 Jun 2018 15:53:26 GMT

Same approach as @patrick_digan and @NicoleJohnson!

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

Prab — Mon, 25 Jun 2018 16:09:59 GMT

Solution attached.

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

Kenda — Mon, 25 Jun 2018 16:10:19 GMT

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

jakevanhecke — Mon, 25 Jun 2018 16:13:59 GMT

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

jvansistine — Mon, 25 Jun 2018 16:15:59 GMT

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

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

neilgallen — Mon, 25 Jun 2018 16:26:54 GMT

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

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

Ladarthure — Mon, 25 Jun 2018 16:54:24 GMT

a simple solution for this one :)

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

Laabsky — Mon, 25 Jun 2018 17:03:18 GMT

At first I was a little stymied, but then I got it in 3 tools.

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

kcgreen — Mon, 25 Jun 2018 17:04:52 GMT

Done

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

svenk — Mon, 25 Jun 2018 17:05:46 GMT

My Solution!

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

bdaniels — Mon, 25 Jun 2018 17:26:37 GMT

solution

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

ggruccio — Mon, 25 Jun 2018 17:26:50 GMT

Love seeing all the participation in the weekly challenges!

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

ckings — Mon, 25 Jun 2018 17:49:38 GMT

I really struggle with the multi-row tool so this was a great challenge! Two tools but took a long time to get my multi row to work though.

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

ponraj — Mon, 25 Jun 2018 18:21:34 GMT

was able to produce the desired results using record ID and Multi row formula tool.

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

dlrustvold — Mon, 25 Jun 2018 18:38:03 GMT

My first posted solution (last week's is still too much of a mess). I went with a summary tool rather than a multi-line formula, and did some superfluous data prep to be robust to a general input.

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

SnehaMatte — Mon, 25 Jun 2018 18:44:08 GMT

More of the usual I guess.