Forum Discussion
Rank Question
I have this rank column:
Rank =
VAR Symbol = V_ACCT[visit_mr_num]
RETURN
RANKX (
FILTER ( ALL ( V_ACCT ), V_ACCT[visit_mr_num] = Symbol ) ,
V_ACCT[Admit Date],
,
ASC
)
See my screenshot below. Why would it not go in order of 1,2,3 in the blue box but does for the other one? There are only 3 records with the mr_num of 001029478.
Hi kattlees,
I tested the above Rank formula on my side, it returned correct rank values as you can see in below image. It also display correctly when I add fields to table visual.
Please provide more details about your source data.
Regards,
Yuliana Gu
2 Replies
Hi kattlees,
I tested the above Rank formula on my side, it returned correct rank values as you can see in below image. It also display correctly when I add fields to table visual.
Please provide more details about your source data.
Regards,
Yuliana Gu
It's ordering by the left most Items in the table. So after Visit_mr_num it's then sorting by Guest ID rather than rank.
Can you try moving Rank to be the first column in the table?
