Skip to main content
Question

Calculate rank from the scores for the account

  • December 14, 2021
  • 6 replies
  • 144 views

Forum|alt.badge.img+1

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
Forum|alt.badge.img+3
  • 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
Forum|alt.badge.img+3
  • 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
Forum|alt.badge.img+2
  • 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) 


Forum|alt.badge.img+1
  • Contributor ⭐️
  • September 15, 2022

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


Forum|alt.badge.img
  • Contributor ⭐️⭐️
  • October 26, 2023

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


rrobinson
Forum|alt.badge.img+1
  • Contributor ⭐️⭐️⭐️⭐️
  • July 31, 2024

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