Question

Calculate rank from the scores for the account

  • 14 December 2021
  • 3 replies
  • 14 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


3 replies

Userlevel 7
Badge +2

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

Hi @abhijeetbakare 

 

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

 

Userlevel 7

Hi All,

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

Reply