Does SAC have a Rank function?

[MadhuLodugu48]

I did not find the Rank function in the calculation editor when creating a column that simply ranks values in a measure column like below. Please let me know if there is a way to do this in a story in SAC.

Sales             Rank

200                   4

350                   3

500                   2

800                   1

[Yogeshwar_M]

Hi @MadhuLodugu48 ,

Here are the steps to create rank in story this is not standard method however you can use this way as your requirement is to give rank randomly as per your choice.

1. You need to be create 2 Dummy Rank measure in model level as shown below 

1. Create story top of that to use this rank measure

1. Enter value in Rank as per your requirement, for ex. 

1. Here Total of both rank measures as per your requirement.

Just using control key click on both Rank measure right click on and add client calculation

As shown below

1. Final Output

Kindly upvote/accept as solution if you find it helpful.

Thanks.

[Yogeshwar_M]

Hi @MadhuLodugu48,

Do you want to sort max or min? 

Do you want rank randomly 

SAC have sort function as shown below

Kindly upvote if you find it helpful 

Thanks 

[MadhuLodugu48]

I do not want to sort max and min but want the rank randomly. For a given measure column I want to have another column that ranks the values in the first column like in the image.

[MadhuLodugu48]

Hi @Yogeshwar_M, could you please elaborate on how Dummy measures can be used at the data model level to arrive at the solution I am trying to achieve?

[Yogeshwar_M]

Hi MadhuLodugu,

In model first you need to be create 2 Dummy Measure namely Rank_Profit and Sale then in story add this measure and arrange sequence as per your requirement 

In this measure you can put rank as per your requirement 

In story add calculated measure total this 2 rank measures as shown above.

Kindly upvote and like!

Thanks 😊

[MadhuLodugu48]

Hi @Yogeshwar_M, I still did not get it. What will these Dummy measures contain at the model level? for instance Rank_Sales in your example which is supposed to contain rank values corresponding to the Sales measure column, how do we do it?. Fyi, I am using an account based analytic model. If you don't mind, please explain the steps .

[Yogeshwar_M]

Hi Madhu, Model level this measure doesn't contain any data you have to put data in story level as per your requirement. I will add steps.