Why filtering focuses analysis in Tableau - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to filter sales data for only the year 2023.

Tableau

FILTER YEAR([Order Date]) = [1]

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

A2022

B2023

C2024

D2021

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a year other than 2023

Using a range instead of a single year

Filtering by 2023 focuses the analysis on that specific year, ignoring other years.

2fill in blank

medium

Complete the code to filter sales where the region is 'West'.

Tableau

FILTER [Region] = [1]

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

A"West"

B"North"

C"South"

D"East"

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing the wrong region

Omitting quotes around the region name

Filtering by 'West' region narrows the data to only that geographic area.

3fill in blank

hard

Fix the error in the filter expression to show sales greater than 1000.

Tableau

FILTER [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 '=' instead of '>'

Using '<=' which includes 1000

Using '>' filters sales values greater than 1000, focusing analysis on higher sales.

4fill in blank

hard

Fill both blanks to filter data for 'Technology' category and sales above 500.

Tableau

FILTER [Category] = [1] AND [Sales] [2] 500

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

A"Technology"

B>

C<

D"Furniture"

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong category name

Using '<' instead of '>' for sales

Filtering by 'Technology' category and sales greater than 500 narrows focus to high sales in that category.

5fill in blank

hard

Fill all three blanks to filter orders from 'East' region, year 2022, and sales less than 2000.

Tableau

FILTER [Region] = [1] AND YEAR([Order Date]) = [2] AND [Sales] [3] 2000

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

A"East"

B2022

C<

D"West"

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong region

Using wrong year

Using '>' instead of '<' for sales

This filter focuses analysis on sales less than 2000 in the East region during 2022.