-
1. Re: Sorting Tables
Diego ParkerFeb 12, 2019 7:15 AM (in response to Andrew Kent)
Hey Andrew,
I have a problem understanding your requirement. You just want to sort by Position 1? If you want to do this, you just need to go next to "position1" and sort it there.
With the Team field included, you can't sort the three position columns descending as the teams have different values for each column.
I hope this helps. If does, please mark it as helpful/correct so other users can refer to it. If it doesn't, could you please further explain your requirement and maybe share your workbook? Thanks!
Best,
Diego
-
2. Re: Sorting Tables
Andrew Kent Feb 13, 2019 3:52 AM (in response to Diego Parker)Hi,
Not quite, the measure [position] has three results, 1, 2 and 3. The current sort is an aggregation of the total number. What I want to do is sort [position] so it goes in order of 1,2 and 3 not the total of all three. so therefore it looks like this;
At the moment the closest I can get is this;
-
3. Re: Sorting Tables
Zhouyi ZhangFeb 13, 2019 3:59 AM (in response to Andrew Kent)
Hi, Andrew
Can you provide a sample workbook?
ZZ
-
4. Re: Sorting Tables
Andrew Kent Feb 13, 2019 4:07 AM (in response to Zhouyi Zhang)I'm not sure if I can do that working in Tableau Public? I can only save to my online profile. how do I share it with you?
-
5. Re: Sorting Tables
Zhouyi ZhangFeb 13, 2019 4:14 AM (in response to Andrew Kent)
you can reply this thread with your public link so I am able to down from there
ZZ
-
6. Re: Sorting Tables
Andrew Kent Feb 13, 2019 6:16 AM (in response to Zhouyi Zhang)Ah I see, okay here you go.
-
-
8. Re: Sorting Tables
Andrew Kent Feb 14, 2019 3:47 AM (in response to Zhouyi Zhang)Hi,
That's working perfectly now thank you! One final question; how do I adapt this further so that blanks/NULLS in this table are displayed as 0? That would really round it off!
Andy
-
9. Re: Sorting Tables
Zhouyi ZhangFeb 14, 2019 3:57 AM (in response to Andrew Kent)
Hi, Andrew
use ZN(Lookup(sum([Number of Records]),0)) instead the sum([Number of records]) in the text
ZZ
-
-
11. Re: Sorting Tables
Zhouyi ZhangFeb 14, 2019 4:38 AM (in response to Andrew Kent)
2 of 2 people found this helpful -
12. Re: Sorting Tables
Andrew Kent Feb 14, 2019 8:56 AM (in response to Zhouyi Zhang)Hi there,
Thanks for your help, this worked perfectly!
Andy
-
13. Re: Sorting Tables
Zhouyi ZhangFeb 14, 2019 6:03 PM (in response to Andrew Kent)
Hi, Andrew
Glad it works finally.
If this solves your question, can you please mark my answer as correct to close the thread?
ZZ
-
14. Re: Sorting Tables
Andrew Kent Feb 18, 2019 10:39 AM (in response to Zhouyi Zhang)Hi there,
I now have a finished dashboard and although this tip works when all the data is displayed, changing filters and parameters seems to have no effect on the order. Can you help? The dashboard is here