cancel
Showing results for 
Search instead for 
Did you mean: 

Does SAC have a Rank function?

MadhuLodugu
Explorer
0 Kudos
223

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Yogeshwar_M
Explorer

Hi @MadhuLodugu ,

You can do this just right click on measure section as shown below then

add client calculation as shown in below

Yogeshwar_M_0-1738771374769.png

After click on Rank Number on column will add to show rank

Yogeshwar_M_1-1738771471166.png

Kindly upvote and like if you find it useful.

Thanks

 

MadhuLodugu
Explorer
0 Kudos
Hi Yogeshwar, Thank you but that is not all. I want to be able to create similar Rank columns for a couple of measures in the able and then be able to add the values in the Rank columns horizontally (row) and then arrive at a Final column which contains the sum of rank values in each cell. I could not achieve this with the method you specified above. I am curious to know if a calculated rank column can be created manually like other calculations so that my requirement can be achieved?
Yogeshwar_M
Explorer
0 Kudos

Hi MadhuLodugu,

You can achieve this by creating dummy measure in model Here below shows sample.

I have 2 measure Profit and Sale

Then I create 2 Rank column for Rank_Profit and Rank_Sale 

Then Sum of Rank

You can give rank as per your choice then addition of this rank measures in last column As shown below

Yogeshwar_M_0-1738855218667.png

Thanks.

 

MadhuLodugu
Explorer
0 Kudos
Yogeshwar, I did not understand how the rank columns can be created in the model. could you please explain. There is no rank function at the model level to my knowledge.
Yogeshwar_M
Explorer
0 Kudos

Hi @MadhuLodugu,

Do you want to sort max or min? 

Do you want rank randomly 

SAC have sort function as shown below

 

VALUESORTING_SS_C.png

Kindly upvote if you find it helpful 

Thanks 

MadhuLodugu
Explorer
0 Kudos
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.
MadhuLodugu
Explorer
0 Kudos
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
Explorer
0 Kudos

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 😊

MadhuLodugu
Explorer
0 Kudos
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
Explorer
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.