Data sorting is the process of arranging the given data in a systematic way based on your requirements.
The data present in the visualization and worksheet can be sort based on the requirement. It can sort the data based on data source order, ascending, descending, or depend on any measured value.
The following example demonstrates Data sorting:
- Open Tableau and click on Connect to Data.
- Then the Connect page will open, click on Microsoft Excel.
- Navigate to the downloaded files, select Sample Superstore.xls excel file, which is a saved excel file, and click on Open.
- You can download a Sample Superstore.xls file from the link: https://chercher.tech/files/
- Once the data source has been connected, open a new worksheet by clicking on sheet1.
- The Sample Superstore excel file contains the below details.
- Here, I am connecting the Sample Superstore excel file to demonstrate this example.
- Drag Orders sheet to workspace window.
- Next, click on Sheet1, it will navigate you to the sheet1 in the Tableau.
- Now, drag Sales measure into the columns and Sub-category to the rows, you will see the bar graph as shown below.
- Click on verticle lines in the Sub-Category, you will get the sorting options.
- Select the Sort option from the dropdown.
- Once you click on the Sort option, you will navigate to the Sort window as shown below, in this window you can select either ascending or descending and then select the field name.
- Ascending : It sorts the order of selected dimensions in ascending order.
- Descending : It sorts the order of selected dimensions in descending order.
- Click the Sort By dropdown, then you will get the below options in the drop-down.
Tableau Data Relationship