-
1. Re: HELP! Ranking Order in Tableau Table
Rody Zakovich Sep 22, 2015 9:47 AM (in response to Rebecca Bauer)Hello Rebecca,
I put together something a few days ago that deals with a similar issue.
Maintaining Rank and Sort with a Lower Level Dimension
Let me know if this wasn't what you needed.
Regards,
Rody
-
2. Re: HELP! Ranking Order in Tableau Table
Kris Erickson Sep 22, 2015 9:54 AM (in response to Rebecca Bauer)So are you saying you'd like it to always say 1,2,3 regardless of the sort?
It looks like you may want to use "index()" instead of "rank()".
See attached.
-
SuperStore_table.twbx 581.2 KB
-
-
3. Re: HELP! Ranking Order in Tableau Table
Rebecca Bauer Sep 22, 2015 10:26 AM (in response to Kris Erickson)Yes I believe you are correct that Index is the formula to use as it is working great on your example. For some reason on my workbook when I sort by any of the measures it changes the index number. How do you keep that consistent as 1, 2, 3 regardless of the sort applied? Thanks so much for your help!!
-
4. Re: HELP! Ranking Order in Tableau Table
Daniel Vincent Sep 22, 2015 10:32 AM (in response to Rebecca Bauer)If you're doing compute using Table Down for the index() then it should number Asc based on whatever your sort is.
-
5. Re: HELP! Ranking Order in Tableau Table
Kris Erickson Sep 22, 2015 10:35 AM (in response to Rebecca Bauer)1 of 1 people found this helpfulI just have the index field going "down". I can't see any other reason why it wouldn't work.
-
6. Re: HELP! Ranking Order in Tableau Table
Rebecca Bauer Sep 22, 2015 10:37 AM (in response to Daniel Vincent)Thank you! Yes! It seems to be working now. YAY!! So appreciate all your help and quick responses Rody Zakovich,Kris EricksonDaniel Vincent!