Tableau Sorting: A Rule That Re-Runs, or an Order You Froze
By the end of this page you can sort any Tableau view four different ways, and say for each one whether it will still be correct after the data refreshes. That second part is the one that catches people, because a sort that's gone stale looks exactly like a sort that's working. It's about twelve minutes. Here's the move to make today. Open a bar chart you've built and ask which of these you did:…
Tableau provides four ways to sort data in a view, each with distinct differences. The first three methods - data source order, alphabetic, and field sort - are computed sorts that re-evaluate as new data is added. These sorts are based on rules that Tableau applies to the data, ensuring the correct order even when new information is included. In contrast, the manual sort option allows users to manually arrange data by dragging and dropping values, creating a fixed order that does not update with new data.
The computed sorts are considered "rules" because they rely on predefined methods to determine the order of data. When new information is introduced, these sorts automatically adjust to maintain the correct sequence. On the other hand, the manual sort is an "arrangement" because it sets a specific order that remains unchanged, regardless of new data additions. This distinction is crucial, as it impacts how the data appears after a data refresh.
For example, if you sort a set of bars from largest to smallest using a computed sort, a new, larger bar will automatically move to the top position when the data refreshes. However, with a manual sort, the new bar would simply be appended at the bottom, below the existing sorted bars. This difference can significantly affect the interpretation of the data, especially when ranking or comparing items based on numerical values.
In Tableau certification exams, understanding the difference between computed and manual sorts is essential. Sorting is objective 2.3.1 on the Tableau Desktop Foundations exam, and the distinction between the two sorting methods is a key focus.
When creating charts, such as a top ten customers chart, it is generally recommended to use a computed sort, like "top ten," because the ranking should be based on a rule that adapts to new data. However, there are situations where a manual sort might be useful, such as when the order represents a specific meaning or categorization not directly reflected in the data itself.
Written by urgent.news from Dev.to's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.
