Question Re: Does SAC have a Rank function? in Technology Q&A

Does SAC have a Rank function?

MadhuLodugu48 — Tue, 04 Feb 2025 17:04:06 GMT

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

Re: Does SAC have a Rank function?

Yogeshwar_M — Tue, 04 Feb 2025 17:34:14 GMT

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

Re: Does SAC have a Rank function?

MadhuLodugu48 — Wed, 05 Feb 2025 14:39:11 GMT

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.

Re: Does SAC have a Rank function?

Yogeshwar_M — Wed, 05 Feb 2025 16:06:59 GMT

Hi @MadhuLodugu48 ,

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

add client calculation as shown in below

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

Kindly upvote and like if you find it useful.

Thanks

Re: Does SAC have a Rank function?

MadhuLodugu48 — Thu, 06 Feb 2025 10:49:02 GMT

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?

Re: Does SAC have a Rank function?

Yogeshwar_M — Thu, 06 Feb 2025 15:26:01 GMT

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

Thanks.

Re: Does SAC have a Rank function?

MadhuLodugu48 — Wed, 12 Feb 2025 10:23:40 GMT

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.

Re: Does SAC have a Rank function?

MadhuLodugu48 — Thu, 13 Feb 2025 15:56:19 GMT

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?

Re: Does SAC have a Rank function?

Yogeshwar_M — Thu, 13 Feb 2025 17:58:12 GMT

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 😊

Re: Does SAC have a Rank function?

MadhuLodugu48 — Fri, 14 Feb 2025 09:38:14 GMT

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 .

Re: Does SAC have a Rank function?

Yogeshwar_M — Sun, 23 Feb 2025 04:50:15 GMT

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.

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

Create story top of that to use this rank measure

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

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

Final Output

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

Thanks.

Re: Does SAC have a Rank function?

Yogeshwar_M — Fri, 14 Feb 2025 10:47:08 GMT

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.