-
1. Re: How to sort by a calculated field that is a table calculation?
Shawn Wallwork Jan 8, 2013 4:04 AM (in response to Leticia Soroa)Leticia, this does sound possible. Sort gets I little tricky and is dependent on the arrangement of pills and aggregations. So it hard to help you without seeing a sample workbook. If you can't share the data, either dummy it up, or use the Super Store to mock-up something similar, and then post a package workbook.
A lot of time the solution is to create a set of two fields for sorting purposes. You can search the KB for these techniques.
--Shawn
-
2. Re: How to sort by a calculated field that is a table calculation?
Leticia Soroa Jan 8, 2013 5:26 AM (in response to Shawn Wallwork)Hi Shawn,
Thank you very much for replying.
Please find attached a mock-up workbook. I have sorted the table by the % Difference by clicking on "% Difference - Sort" however as I cannot set this up at issuer level as soon as I change the parameter it stops working.
Thanks,
Leticia
-
TableauMockUp.twbx.zip 28.1 KB
-
-
3. Re: How to sort by a calculated field that is a table calculation?
Shawn Wallwork Jan 8, 2013 9:09 AM (in response to Leticia Soroa)Pinging Alex. I worked on this one for awhile, but I just can't see it. Close but can seem to get there.
--Shawn
-
4. Re: How to sort by a calculated field that is a table calculation?
Alex Kerin Jan 8, 2013 9:33 AM (in response to Shawn Wallwork)Do you care about showing the prior date? Here I just pulled a discrete copy of % measure over before the issuername, and then hid the null values (from the prior date) and chose not to show the column (hide headers)
-
TableauMockUp AK.twbx.zip 31.2 KB
-
-
5. Re: How to sort by a calculated field that is a table calculation?
Shawn Wallwork Jan 8, 2013 9:35 AM (in response to Alex Kerin)Yep I did that too.
--Shawn
-
6. Re: How to sort by a calculated field that is a table calculation?
Robin Kennedy Jan 8, 2013 9:43 AM (in response to Leticia Soroa)Can kind of get it by fiddling with the % diff calc, but the nulls are always at the top which is annoying and the Rank field breaks
-
TableauMockUp.twbx.zip 32.4 KB
-
-
7. Re: How to sort by a calculated field that is a table calculation?
Leticia Soroa Jan 8, 2013 9:49 AM (in response to Leticia Soroa)1 of 1 people found this helpfulHi guys,
Thanks for your help!
Alex\Shawn - I need to show both dates as both values are relevant.
Robin - This kind of works but is there a way to eliminate the null values? somehow adding a filter?
Thanks a lot again!
-
8. Re: How to sort by a calculated field that is a table calculation?
Alex Kerin Jan 8, 2013 9:49 AM (in response to Shawn Wallwork)Then how about another calc to pull in the prior date with a lookup (same as the % diff uses)?
-
TableauMockUp AK2.twbx.zip 55.7 KB
-
-
9. Re: How to sort by a calculated field that is a table calculation?
Alex Kerin Jan 8, 2013 9:50 AM (in response to Leticia Soroa)I think my second version fixes it
-
10. Re: How to sort by a calculated field that is a table calculation?
Leticia Soroa Jan 8, 2013 9:52 AM (in response to Alex Kerin)Hi Alex,
The order in the second version does not seem correct when using column2.
-
12. Re: How to sort by a calculated field that is a table calculation?
Robin Kennedy Jan 8, 2013 9:55 AM (in response to Leticia Soroa)Click show header on the Sorting pill, then click the null on the Sorting column that comes up and click exclude. The rehide the headers again
-
13. Re: How to sort by a calculated field that is a table calculation?
Alex Kerin Jan 8, 2013 9:58 AM (in response to Robin Kennedy)I like your way of doing it Robin - neater.
-
14. Re: How to sort by a calculated field that is a table calculation?
Leticia Soroa Jan 8, 2013 9:59 AM (in response to Robin Kennedy)Yeah it does!! that is excellent!! thank you very much for your help guys!