Manual sort order in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a manual sort order using a calculated field in Tableau.

Tableau

CASE [Category]
  WHEN 'Furniture' THEN [1]
  WHEN 'Office Supplies' THEN 2
  WHEN 'Technology' THEN 3
  ELSE 4
END

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

A0

B1

C'1'

D'A'

Attempts:

3 left

💡 Hint

Common Mistakes

Using quotes around numbers which makes them strings.

Assigning zero which might cause unexpected sorting.

In Tableau, manual sort order can be created by assigning numeric values to categories. The number 1 is used here to assign the highest priority to 'Furniture'.

2fill in blank

medium

Complete the code to sort products manually by priority using a calculated field.

Tableau

IF [Product] = 'Printer' THEN [1] ELSE 2 END

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

A1

B0

C'1'

D3

Attempts:

3 left

💡 Hint

Common Mistakes

Using string values instead of numbers.

Assigning zero which might cause sorting issues.

Assigning 1 to 'Printer' gives it the highest priority in sorting.

3fill in blank

hard

Fix the error in the manual sort order calculation.

Tableau

CASE [Region]
  WHEN 'East' THEN [1]
  WHEN 'West' THEN 2
  WHEN 'South' THEN 3
  ELSE 4
END

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

A'1'

B0

COne

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Using string values instead of numbers.

Using text like 'One' instead of numeric values.

Numbers should be used without quotes for sorting in Tableau. Using '1' as a string causes errors.

4fill in blank

hard

Fill both blanks to assign manual sort order for categories and subcategories.

Tableau

CASE [Category]
  WHEN 'Technology' THEN [1]
  WHEN 'Furniture' THEN [2]
  ELSE 3
END

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

A1

B2

C'1'

D'2'

Attempts:

3 left

💡 Hint

Common Mistakes

Using quoted numbers which are treated as strings.

Mixing up the order numbers.

Use numeric values without quotes to assign manual sort order: 1 for Technology and 2 for Furniture.

5fill in blank

hard

Fill all three blanks to create a manual sort order for regions with priority.

Tableau

CASE [Region]
  WHEN 'North' THEN [1]
  WHEN 'East' THEN [2]
  WHEN 'West' THEN [3]
  ELSE 4
END

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

A1

B2

C3

D'1'

Attempts:

3 left

💡 Hint

Common Mistakes

Using quoted numbers which are treated as strings.

Assigning the same number to multiple regions.

Assign numeric values 1, 2, and 3 without quotes to set manual sort order for North, East, and West regions respectively.