Sorting by two columns at a single time

Question & Answer
1

How can i sort the visual by two columns at one time?? I have already tried by using calculated field and have also tried by creating separate column rank in my table

2

@deelasha please refer this community post - Sorting by multiple columns for sorting multiple columns using rank function

3

@DeepakS I have already tried that option. I need to sort by member_id and pathway and if i apply that rank it will only sort by member_id not by pathway. I tried to concat member_id and pathway and make a separate column as rank in backend itself a sort by that column rank in frontend but the problem is some of the same member_id gets splited in between(here splitted means in between of same memberid other memberid came between them). i need same member_id continuously in pathway order for all member_id.

4

@deelasha , in that case use the denserank function denseRank - Amazon QuickSight. Let me know if this doesn’t work for your use case.

6

@DeepakS Denserank function will not work when i use in Calculated field. But it works when I us in my backend query and make separate column and use it to sort.
Thank you, @DeepakS , for your prompt response. I appreciate your assistance and attention to my problem.