Why sorting organizes visual display in Tableau - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to sort the bar chart by sales in descending order.

Tableau

SORT BY [1] DESC

Drag options to blanks, or click blank then click option'

ASales

BProfit

CCategory

DDate

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a dimension like Category instead of a measure like Sales.

Sorting by Sales in descending order arranges the bars from highest to lowest sales, making it easier to compare values visually.

2fill in blank

medium

Complete the code to sort the table by Region alphabetically.

Tableau

SORT BY [1] ASC

Drag options to blanks, or click blank then click option'

AOrder Date

BRegion

CProfit

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Sorting by numeric fields instead of the Region name.

Sorting by Region in ascending order arranges the table alphabetically, making it easier to find regions.

3fill in blank

hard

Fix the error in the sorting expression to order products by profit descending.

Tableau

SORT BY [1] DESC

Drag options to blanks, or click blank then click option'

ASales

BCategory

CQuantity

DProfit

Attempts:

3 left

💡 Hint

Common Mistakes

Sorting by Sales or Quantity instead of Profit.

Sorting by Profit descending shows the most profitable products first, which helps focus on top earners.

4fill in blank

hard

Fill both blanks to sort the dashboard by Date ascending and then by Sales descending.

Tableau

SORT BY [1] ASC, [2] DESC

Drag options to blanks, or click blank then click option'

ADate

BSales

CProfit

DRegion

Attempts:

3 left

💡 Hint

Common Mistakes

Reversing the order or sorting by wrong fields.

Sorting first by Date ascending organizes data chronologically, then sorting by Sales descending within each date highlights top sales.

5fill in blank

hard

Fill all three blanks to sort the report by Category ascending, then by Profit descending, and finally by Region ascending.

Tableau

SORT BY [1] ASC, [2] DESC, [3] ASC

Drag options to blanks, or click blank then click option'

ACategory

BProfit

CRegion

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up ascending and descending orders or wrong fields.

This sorting order groups data by Category alphabetically, then highlights the most profitable items within each category, and finally organizes regions alphabetically.