Does the calculation have fields coming from a secondary data source? Is the calculation result in a table calculation? These will not be available for sorting.
Hi Alex and Shawn - thanks for the quick replies. As Shawn suggests, the calculated field indeed is derived in part from a secondary data source; apologies for not mentioning that in my original post (I had assumed that the aggregation was the issue). In that case, is this still a multi-pass issue? If not, is there a specific technical reason why this functionality is not supported?
Thanks again for the help!
The Tableau v8.1 multi-pass refers to Subtotals and Grand Totals, which can now have a secondary aggregation, so you can do things like have SUM(Sales) as your measure and then show the average of SUM(Sales) as your total. Although the multi-pass will operate on measures from secondary sources, it will not operate on calculated fields that are derived from a combination of primary and secondary sources, will not operate on table calculations either.
I don't know the exact technical reasons why Tableau does not support sorting dimensions by secondary measures or by blended calculations, from conversations with Tableau developers it's clear that there are reasons, and they are thinking about how to solve those problems, and any solutions won't be part of 8.1, which is already in beta.
Depending on the particular view, there are some hacks like using a discrete version of a measure that is set up to have an alphanumeric sort that gives the desired results, if you'd like an example please post a packaged workbook with some sample data that represents your situation.
Thank you very much for clarifying that, Jonathan!
Apologies for the late follow-up; our team found a way to execute this specific visualization by creating a dedicated view to be used through a new data connection (which is fine for our purposes). Thank you again for the careful explanation and offer of help!
You're welcome, I'm glad you got a solution that works for you!
I am facing the same problem of sorting on an aggregated calculated field. Can you please explain how you where able to do this.
Thanks in Advance
The answer is Kyle's last post: Re: Wanted in 8.1: Sorting by Aggregated (AGG) Calculated Fields
Due to the age of the original post I recommend starting a new post and explaining exactly what the issue is you are having.