Data present in the worksheet can be sorted based on the requirement. It can sort the data based on the data source such as ascending, descending order, or depend on any measured value.

The procedure for sorting the data is given below, step by step:

For example, consider a data source such as sample-superstore, and you want to sort the dimensions and the measures fields as follows.

Step1: Add the sample-superstore data source with Tableau and drag the Order table to the pane shown in the below screenshot.

Step2: Go to the worksheet and drag the dimension Category to the row shelf and the measure Sales to the column shelf.

It creates a horizontal bar chart. Category field present in the visual order, and it is sorted based on data source by default. We can change the order of sorting by following the below procedure.

Step3: Right-click on the Category field and select Sort option.

After that, it opens the Sort window. All options present inside the sort window is shown below as follows:

Sort Order

Ascending: It sorts the order of selected dimensions and measures in ascending order.
Descending: It sorts the order of selected dimensions and measures in descending order.

Sort By

The field can be sorted in different types of methods that are explained below as follows.

Data source order: It sorts the field based on data source order.
Alphabetic: It sorts the dimensions and measures in alphabetical order.
Field: It sorts the field based on the other measure or dimension values.
Manual: It can manually sort the data.

For example, suppose the Category field is sorted based on another field such as ‘Sales‘.

Step1: Click on ‘Field‘ radio button.

Step2: Select the field on which the Category is to be filtered.

Step3: Select the aggregation type.

Step4: Click on Clear button.

In the above example, it filters the Category field based on the sum of sales in ascending order. And it sorts the data which is shown in below screenshot.

So, this brings us to the end of blog. This Tecklearn ‘Sorting Data in Tableau’ blog helps you with commonly asked questions if you are looking out for a job in Tableau Desktop. If you wish to learn Tableau Desktop and build a career in Business Intelligence domain, then check out our interactive, Tableau Desktop Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/tableau-desktop/

Tableau Desktop Training

About the Course

Tecklearn’s Tableau Desktop Training teach you how to transform raw data into interactive and shareable dashboards using Tableau. Our Tableau Course covers the necessary analytical skills to Advanced data visualizations by incorporating real-world use-case scenarios, labs, and exercises. Some of the topics included are Data Blending, Data Mapping, Graphs, creation of charts, and LOD expression by using different versions of Tableau, such as Tableau Desktop, Tableau Reader, and Tableau Public.

Why Should you take Tableau Desktop Training?

The average salary of a Tableau Professional ranges between $108,697 to $158,000 per annum -Indeed.com.
Tableau has been positioned as a Leader in the Gartner Magic Quadrant for Analytics and Business Intelligence Platforms – Gartner.com.
Fidelity Investments, Capgemini, EY, Deloitte, EY, JP Morgan, Verizon, Facebook, Dell, General Motors, KPMG, Bank of America and 40,000 other MNCs worldwide across industries use Tableau.

What you will Learn in this Course?

Understanding Tableau

Why Tableau
Tableau Product Platforms
Tableau Architecture
Tableau Interface

Data Connection with Tableau Desktop

Features of Tableau Desktop
Connect to data from File and Database
Types of Connections
Data Blending
Joins and Unions
Tableau Desktop User Interface
Basic project: Create a workbook and publish it on Tableau Online

Basic Visual Analytics

Visual Analytics
Basic Charts: Bar Chart, Line Chart, and Pie Chart
Hierarchies
Data Granularity
Highlighting
Sorting
Filtering
Grouping
Sets

Advanced Visual Analytics

Parameters
Tool tips
Trend lines
Reference lines
Forecasting
Clustering

Calculations in Tableau

Calculated Fields
Numeric, String, Data, Logical, Addressing and Partitioning
Table Calculations

Level of Detail (LOD’s) Calculations

Advanced Charts in Tableau

Box and Whisker’s Plot
Bullet Chart
Bar in Bar Chart
Gantt Chart
Waterfall Chart
Pareto Chart
Control Chart
Funnel Chart
Bump Chart

Parameters

What If Scenarios
Parameter in CF (KPI control)
Parameter in Filter (Top N)
Parameter in reference line

Dashboards and Stories

Introduction to Dashboards
The Dashboard Interface
Dashboard Objects
Building a Dashboard
Dashboard Layouts and Formatting
Interactive Dashboards with actions
Designing Dashboards for devices
Story Points

Data Security in Tableau

Optimizations tips and tricks

Interacting with Tableau Server

Working with Tableau JavaScript API

Got a question for us? Please mention it in the comments section and we will get back to you.

575