Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Ranking in Alteryx

alt_tush
9 - Comet

Hello Everyone,

 

I have below column Number. I want to rank those numbers according to their sequence. i.e. for max value rank should be 1 and lower value rank should be max.

In below table for number 28 we assigned the rank 1 and for 4 rank is 7. I calculated this rank in excel using Rank formula "RANK(A2,$A$2:$A$8)". 

 

Is there any formula in Alteryx which can give me the same result.

 

Here number 28 is twice so Rank function applied same rank for both i.e. 1 and skipped rank 2.

If there is 28 three times then Rank function applied same rank for three same entries and skipped 2 and 3.

 

 

NumberRank
106
234
253
281
47
281
115

 

Thank you in advance.

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @alt_tush I mocked up an approach which produces the output you describe let me know what you think?

 

Rank_19052021.JPG

alt_tush
9 - Comet

Hi JosephSerpis,

 

Thank you for your quick response 🙂

 

Yes i have also the same approach but i am looking for some alternative or functions which can give me the output by using these sorting multirow or recordID tool.

 

Thanks again. This is useful and it has resolved my issue,

Labels
Top Solution Authors