2 weeks ago
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
Request clarification before answering.
Hi @MadhuLodugu ,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Hi @MadhuLodugu,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 😊
User | Count |
---|---|
60 | |
10 | |
8 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.