KNOWLEDGE BASE

Quick sort buttons in header do not sort correctly


Published: 05 Dec 2015
Last Modified Date: 10 Mar 2017

Issue

When clicking the quick sort button in a header the results are not in the expected order.

Resolution

In certain views, clicking the quick sort button produces unexpected results.
sort descending

 

The reason is that the view is misleading, by creating a dual axis chart using ATTR(1) the view only looks like a single column.  However, it is actually a scatterplot, and the quick sort is sorting by the measure that makes up that axis, in this case ATTR(1).

 

To achieve the desired sort, Right click on the dimension on the rows shelf and select sort.   Select Ascending, descending and the field and aggregation as desired for the sort.

 

To make this dynamic, use parameters as described in the following article

http://kb.tableau.com/articles/knowledgebase/sort-using-parameter-control
Did this article resolve the issue?