Let’s think, you have data about local book store. They have tracked how many books were sold for each of the genres. But you still have questions about data. For example, Did history book sell more books than science fiction. But they are so close to eachother and it is hard to tell. What about other types of books ? To say something about this we should sort the data.

In tableau we have two type of sorting options; Computed Sorting and Manual Sorts.

Computed Sorting : A computed sort organizes the data by applying rules, such as, “sort this list alphabetically” or ” sort these rows to show the quantities in descending order.” With this data set, sorting the list alphabetically by genre name. And sorting the genres by how many books sold are both computed sorts. In tableau workspace you easily conduct sorting options:

As you see above, you just need to right click any dimension or measure then click the sort options. For example you choose the data source order then choose the ascending or descending order option. Sortin option very helpful while you are working on large scale data. You easily determine what you wan’t. Computed sorts are dynamic. If your data changes, Tableau can uptade the view. Just you need to refresh the tableau.

Manual Sorting : Manual sort is a specific order that you wan’t your data to be in. With a manual sort you tell tableau what you want. You can move specific genre to the top of the list. Just you have to to that drop and move the genre. Manual sorts are maintaned even when the data changes. For example when books were sorted by number of books sold before. When solded books number changes the sorts will uptade as well.

In this article, we have learned how to sort your data in tableau. Sorting is very useful options because data can be messy or can be unreadable. Please don’t forget to subscribe my blog. See you

Leave a Reply