Field sort (alphabetic, data source) in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to sort the field alphabetically in Tableau calculated field.

Tableau

SORT([Category], [1])

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

ASUM

BDESC

CASC

DAVG

Attempts:

3 left

💡 Hint

Common Mistakes

Using DESC will sort in reverse alphabetical order.

Using aggregation functions like SUM or AVG will cause errors here.

Use ASC to sort the field alphabetically in ascending order.

2fill in blank

medium

Complete the code to sort the field by data source order in Tableau.

Tableau

SORT([Region], [1])

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

AASC

BDATA_SOURCE_ORDER

CDESC

DRANK

Attempts:

3 left

💡 Hint

Common Mistakes

Using ASC or DESC will sort alphabetically, not by data source order.

RANK is not a valid sorting option here.

Use DATA_SOURCE_ORDER to sort the field in the order it appears in the data source.

3fill in blank

hard

Fix the error in the code to sort the field alphabetically ascending.

Tableau

SORT([Product], [1])

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

AASC

BDESC

CSUM

DMAX

Attempts:

3 left

💡 Hint

Common Mistakes

Using DESC sorts in descending order, which is reverse alphabetical.

Using aggregation functions causes errors.

The correct sorting order for ascending alphabetical sort is ASC.

4fill in blank

hard

Fill both blanks to sort the field by data source order and then alphabetically descending.

Tableau

SORT([Segment], [1]) THEN SORT([Segment], [2])

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

ADATA_SOURCE_ORDER

BDESC

CASC

DRANK

Attempts:

3 left

💡 Hint

Common Mistakes

Using ASC instead of DESC for the second sort.

Using RANK which is not a sorting order here.

First sort by DATA_SOURCE_ORDER to keep data source order, then by DESC for descending alphabetical order.

5fill in blank

hard

Fill all three blanks to sort the field alphabetically ascending, then by data source order, and finally descending.

Tableau

SORT([Category], [1]) THEN SORT([Category], [2]) THEN SORT([Category], [3])

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

AASC

BDATA_SOURCE_ORDER

CDESC

DRANK

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up ASC and DESC orders.

Using RANK which is not a valid sorting order here.

Sort first alphabetically ascending (ASC), then by data source order (DATA_SOURCE_ORDER), and finally descending (DESC).