Change sort order with buttons in Tableau Software is helping every end user to easily sort ascending or descending attributes according to different criteria. Watch our video.
In order to create a Highlight on Row and Column in Tableau, please follow these steps:
In Tableau Desktop, connect to Superstore sample data provided by Tableau Software.
→ Create a parameter, named Sort Order and select it from Data type as Integer and from Allowable values as List.
→ In the List of values area, for Value type the values 1 and -1 and for Display As type the values Descending and Ascending.
→ Create a calculated field named Descending with the formula: MIN(1).
→ Create a calculated field named Ascending with the formula: MIN(-1).
→ In the Marks area change the display to Shape.
→ Drag the Measure Names field on Rows, on Shape and on Filters.
→ Go to Filters, right click on Measure Names and select Edit Filter. Select only the Ascending and Descending
→ Drag the Measure Values field on Details from Marks
→ Create a new calculated field, named Profit Sort Order with the formula: SUM([Profit])*[Sort Order].
→ Create a new Worksheet and drag the Profit field on Rows and Region field on Columns.
→ Click on Region and select Sort -> Sorty by field. Sort order -> Descending. Field Name -> Profit Sort Order (previously calculated field), Aggregation -> Custom.
→ Create a Dashboard and add a Vertical Container. Add the both sheets, , from Tableau Desktop, business intelligence software.
→ Go to Dashboard -> Actions -> Add action -> Change Parameter. In the Name area select the parameter created for sorting: Sort Order. At Source Sheets check the worksheet in which the parameter is found: Change sort order. Select the Run action on Select. For Target Parameter select Sort Order, for Field select Measure Values (Sample – Superstore) and for Aggregation select Minimum and then click OK.
→ From the sort sheet click on Go to Sheet and on that sheet click on Shape from Marks area and change the shapes for Ascending and Descending.
By Mara Cîșlariu
In this Skillpill, you will learn how to create a Parliament Chart in Tableau. A Parliament Chart, or semicircular chart, represents the distribution of parliamentary seats. It is not a standard chart type in Tableau but can be manually created […]
What is a Context? Contexts are used to configure a Job for standard environments within the Software Development Life Cycle, such as Development, Testing, and Production. A Job always runs within a specific context. When a context is selected in […]
In Talend Cloud Management Console (TMC), you can create executable tasks and execution plans, which can be run directly in the Cloud or with a Remote Engine. You need to create an execution plan to allow automated runs in TMC, […]