Filter actions in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a filter action that filters on the 'Category' field.

Tableau

[Category] [1] "Technology"

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

A=

B<>

C>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<>' instead of '=' will filter out 'Technology' instead of including it.

Using '>' or '<' does not make sense for text fields.

The filter action uses the equals sign '=' to filter the 'Category' field to only show 'Technology'.

2fill in blank

medium

Complete the code to set a filter action that only includes sales greater than 1000.

Tableau

[Sales] [1] 1000

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

A<=

B=

C>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<=' or '<' will include smaller sales values, which is incorrect.

Using '=' will only include sales exactly equal to 1000.

The filter action uses '>' to include only sales values greater than 1000.

3fill in blank

hard

Fix the error in the filter action to correctly filter for 'Region' equal to 'West'.

Tableau

[Region] [1] "West"

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

A<>

B==

C=>

D=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '==' causes syntax errors in Tableau.

Using '=>' is invalid syntax.

Tableau uses a single '=' for equality in filter actions, not '==' or other operators.

4fill in blank

hard

Fill both blanks to filter sales between 500 and 2000 inclusive.

Tableau

[Sales] [1] 500 AND [Sales] [2] 2000

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

A>=

B<

C<=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '>' or '<' excludes boundary values.

Using '<' instead of '<=' excludes 2000.

The filter includes sales greater than or equal to 500 and less than or equal to 2000.

5fill in blank

hard

Fill all three blanks to filter products where Category is 'Furniture', Sales are above 1000, and Region is not 'East'.

Tableau

[Category] [1] "Furniture" AND [Sales] [2] 1000 AND [Region] [3] "East"

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

A=

B>

C<>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '=' instead of '<>' for excluding 'East'.

Using '<' instead of '>' for sales filter.

The filter includes Category equal to 'Furniture', Sales greater than 1000, and excludes Region 'East' using '<>'.