Ascending and descending sort in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to sort the sales data in ascending order by the 'Category' field.

Tableau

SORT([Category], [1])

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

ABOTTOM

BDESC

CTOP

DASC

Attempts:

3 left

💡 Hint

Common Mistakes

Using DESC instead of ASC for ascending sort

Confusing TOP or BOTTOM with sort direction

In Tableau, ASC is used to sort data in ascending order.

2fill in blank

medium

Complete the code to sort the sales data in descending order by the 'Profit' field.

Tableau

SORT([Profit], [1])

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

AASC

BDESC

CMIN

DMAX

Attempts:

3 left

💡 Hint

Common Mistakes

Using ASC instead of DESC for descending sort

Confusing MIN or MAX with sort direction

Use DESC to sort data from largest to smallest values.

3fill in blank

hard

Fix the error in the code to sort the 'Region' field in descending order.

Tableau

SORT([Region], [1])

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

AUP

BDOWN

CDESC

DASC

Attempts:

3 left

💡 Hint

Common Mistakes

Using UP or DOWN which are not valid sort directions

Using ASC instead of DESC for descending sort

The correct keyword for descending sort in Tableau is DESC. UP and DOWN are not valid.

4fill in blank

hard

Fill both blanks to sort the 'Sales' field in ascending order and the 'Quantity' field in descending order.

Tableau

SORT([Sales], [1]) and SORT([Quantity], [2])

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

AASC

BDESC

CTOP

DBOTTOM

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up ASC and DESC

Using TOP or BOTTOM instead of ASC or DESC

Use ASC for ascending sort on Sales and DESC for descending sort on Quantity.

5fill in blank

hard

Fill all three blanks to sort the 'Category' field ascending, 'Profit' descending, and 'Region' ascending.

Tableau

SORT([Category], [1]), SORT([Profit], [2]), SORT([Region], [3])

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

ADESC

BASC

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing ascending and descending keywords

Using the same direction for all fields

Sort Category ascending (ASC), Profit descending (DESC), and Region ascending (ASC).