Dimension filters in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to filter the view to only show data where the 'Region' dimension equals 'West'.

Tableau

IF [Region] = [1] THEN 'Show' ELSE 'Hide' END

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

A'North'

B'East'

C'West'

D'South'

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting to use quotes around the region name.

Using the wrong region name.

We use 'West' in quotes because it is a string value for the Region dimension.

2fill in blank

medium

Complete the code to create a filter that includes only 'Category' values that are not 'Furniture'.

Tableau

IF [Category] <> [1] THEN 'Include' ELSE 'Exclude' END

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

A'Furniture'

B'Books'

C'Technology'

D'Office Supplies'

Attempts:

3 left

💡 Hint

Common Mistakes

Using '=' instead of '<>'.

Using the wrong category name.

The '<>' operator means 'not equal to'. We exclude 'Furniture' by checking if Category is not 'Furniture'.

3fill in blank

hard

Fix the error in the filter calculation to only show 'Sales' greater than 1000.

Tableau

IF [Sales] [1] 1000 THEN 'High' ELSE 'Low' END

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

A<

B>

C=

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' which filters for sales less than 1000.

Using '=' which filters only sales exactly 1000.

To show sales greater than 1000, use the '>' operator.

4fill in blank

hard

Fill both blanks to create a filter that shows only 'Region' values that are either 'East' or 'South'.

Tableau

IF [Region] = [1] OR [Region] = [2] THEN 'Show' ELSE 'Hide' END

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

A'East'

B'West'

C'South'

D'North'

Attempts:

3 left

💡 Hint

Common Mistakes

Using AND instead of OR which would exclude all rows.

Using wrong region names.

We use OR to include both 'East' and 'South' regions in the filter.

5fill in blank

hard

Fill all three blanks to create a filter that shows 'Category' as 'Technology' and 'Sales' greater than 5000.

Tableau

IF [Category] = [1] AND [Sales] [2] [3] THEN 'Valid' ELSE 'Invalid' END

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

A'Technology'

B>

C5000

D'Furniture'

Attempts:

3 left

💡 Hint

Common Mistakes

Using '=' instead of '>' for Sales comparison.

Using wrong category name.

Mixing up the order of blanks.

This filter checks that Category is 'Technology' and Sales is greater than 5000.