Question

Calculate rank from the scores for the account

  • 14 December 2021
  • 5 replies
  • 81 views

Userlevel 2
Badge +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


5 replies

Userlevel 5
Badge +3

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.

Userlevel 5
Badge +3

Hi @abhijeetbakare 

 

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

 

Userlevel 6
Badge +1

Hi All,

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

Badge +1

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

Badge

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

Reply