Skip to main content
Helper ⭐️
December 14, 2021
Question

Calculate rank from the scores for the account

  • December 14, 2021
  • 6 replies
  • 232 views

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 ⭐️⭐️
April 25, 2022

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.

phani_kumar
Gainsight Employee ⭐️⭐️
May 2, 2022

Hi @abhijeetbakare 

 

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

 

rakesh
Gainsight Employee ⭐️
Lets put your data to work!
May 12, 2022

Hi All,

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

Contributor ⭐️
September 15, 2022

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

Contributor ⭐️⭐️
October 26, 2023

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

rrobinson
Contributor ⭐️⭐️⭐️⭐️⭐️
July 31, 2024

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

-RR