Thursday, 3 December 2015

Sorting in Tableau

Sorting



We can define the Sorting in different Ways.




1) Based upon Single Column (Such as Sorting on Region. Sorting on City). Note Only single at a time.
1.png

2) If you want to Sorting Cities of West in Desc, Cities of Central in Ascending, then we need to select the Region one by one individually on the Work area then Apply the Sorting.


12.png

13.png

114.png


3) The below screen shot is intend to sorting the Report according to "Region' Sales Value".
Before Sorting.png


Defining the Sorting of Region as Sales Volume figures
Sorting Regions - Sales Figure Base 1.png


After Sorting
After Sorting.png


Regions are in Ascending, Cities are in Descending order as Sales Figures
Regions - Asc    City - Desc.png



If we want to Apply sorting using two Fields, We need to combine the Fields like the Below screen shotCombine.png


After combining 2 Fields, we get the New field like below screen shot.
11.png



In the following screen shot, I used the Combined Fields for sorting purpose.111.png





===========================

http://viztableau.blogspot.in/2015/12/how-to-convert-string-to-date.html

1 comment :