Skip to main content
Helper ⭐️
Dec 14, 2021 1:14 PM UTC
Question

Calculate rank from the scores for the account

Hey Guys!
I have data designer fetch in this below format (Account Name, Overall Score). I want to assign them Rank using the formula. Higher the Percentage Higher the rank.
How do I calculate Rank in the data Designer.

I have 2000K  Accounts and all have a unique score. I want the rank to not repeat for any account.
This is same to the school classroom score and then ranking the students

6 replies

phani_kumar
Gainsight Employee ⭐️⭐️
Apr 25, 2022 2:24 PM UTC

Hey Guys!
I have data designer fetch in this below format (Account Name, Overall Score). I want to assign them Rank using the formula. Higher the Percentage Higher the rank.
How do I calculate Rank in the data Designer.

I have 2000K  Accounts and all have a unique score. I want the rank to not repeat for any account.
This is same to the school classroom score and then ranking the students

+1. 

wanted to achieve the same. Need to create rank based on a Field Values in DD or Rules.

Really appreciate if any one have any suggestions or work arounds.

Thanks.

Translate
phani_kumar
Gainsight Employee ⭐️⭐️
May 2, 2022 7:30 AM UTC

Hi @abhijeetbakare 

 

Here is the solution for your use case(Calculating Rank), I have tried this using Rules Engine  and worked well.

 

Translate
rakesh
Gainsight Employee ⭐️
Lets put your data to work!
May 12, 2022 8:37 AM UTC

Hi All,

Want to update that we are planning introducing an out of the box function for ranking in Data Designer (& Rules Engine) 

Translate
Contributor ⭐️
Sep 15, 2022 4:12 PM UTC

@rakesh any update on this out of the box functionality?

Translate
Contributor ⭐️⭐️
Oct 26, 2023 5:58 PM UTC

Has the ranking been introduced yet in Data Designer? Eagerly awaiting this. 

Translate
rrobinson
Contributor ⭐️⭐️⭐️⭐️⭐️
Jul 31, 2024 12:29 PM UTC

Very interested in OOTB functionality around this, top X is a very common report request.

Translate
-RR