Quick filters for interactivity in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to add a quick filter for the 'Region' field in Tableau.

Tableau

Drag the [1] field to the Filters shelf to create a quick filter.

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

ARegion

BSUM(Sales)

CDate

DCustomer ID

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a measure field like SUM(Sales) instead of a dimension.

Selecting a field unrelated to filtering like Customer ID when the task is about Region.

Quick filters are created by dragging a dimension like 'Region' to the Filters shelf.

2fill in blank

medium

Complete the step to show the quick filter control for 'Category' in Tableau.

Tableau

Right-click the 'Category' field on the Filters shelf and select [1] to display the quick filter.

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

AShow Filter

BRemove Filter

CEdit Filter

DHide Filter

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Hide Filter' which does the opposite.

Selecting 'Remove Filter' which deletes the filter.

To make a quick filter visible, you right-click the field and choose 'Show Filter'.

3fill in blank

hard

Fix the error in the quick filter setup to allow multiple selections.

Tableau

In the quick filter options, change the selection type from [1] to 'Multiple Values Dropdown'.

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

AMultiple Values Dropdown

BSingle Value List

CSingle Value Dropdown

DMultiple Values List

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Multiple Values Dropdown' as the current type instead of the one to change from.

Confusing list and dropdown options.

The default is often 'Single Value Dropdown', which allows only one selection. Change it to 'Multiple Values Dropdown' to allow multiple selections.

4fill in blank

hard

Fill both blanks to set a quick filter to only show relevant values and apply it to all worksheets.

Tableau

In the filter menu, check [1] to limit values and select [2] to apply filter across worksheets.

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

AOnly Relevant Values

BAll Values in Database

CApply to Worksheets

DApply to Selected Worksheets

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'All Values in Database' which shows all values regardless of context.

Selecting 'Apply to Worksheets' which is incomplete without specifying which worksheets.

Checking 'Only Relevant Values' limits filter options to those relevant to other filters. 'Apply to Selected Worksheets' lets you apply the filter to multiple sheets.

5fill in blank

hard

Fill all three blanks to create a quick filter that is searchable, shows only relevant values, and applies to all worksheets.

Tableau

Right-click the filter, select [1], enable [2] for filtering options, and choose [3] to apply filter globally.

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

AShow Filter

BOnly Relevant Values

CApply to All Using This Data Source

DShow Filter Card

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing 'Show Filter' with 'Show Filter Card'.

Not selecting the global apply option.

'Show Filter' displays the filter control. 'Only Relevant Values' limits options to relevant ones. 'Apply to All Using This Data Source' applies the filter to all worksheets using that data.

Practice

1. What is the main purpose of a quick filter in Tableau dashboards?

easy

A. To let users choose which data to display easily

B. To change the color scheme of the dashboard

C. To export data to Excel

D. To create new calculated fields

Solution

1. Step 1: Understand the role of quick filters

   Quick filters allow users to select specific data subsets interactively.

2. Step 2: Compare options to the purpose

   Changing colors, exporting data, or creating fields are not the main functions of quick filters.

3. Final Answer:

   To let users choose which data to display easily -> Option A

4. Quick Check:

   Quick filters = user data selection [OK]

Hint: Quick filters let users pick data to see [OK]

Common Mistakes:

• Thinking quick filters change dashboard colors
• Confusing quick filters with exporting features
• Assuming quick filters create new data fields

2. Which of the following is the correct way to add a quick filter for a field named Region in Tableau?

easy

A. Right-click Region and select 'Create Calculated Field'

B. Drag Region to the Tooltip shelf

C. Double-click Region to create a filter

D. Right-click Region field and select 'Show Filter'

Solution

1. Step 1: Identify how to add quick filters in Tableau

   Quick filters are added by right-clicking a field and choosing 'Show Filter'.

2. Step 2: Evaluate the options

   Dragging to Tooltip or creating calculated fields does not add quick filters. Double-clicking creates a pill but not a filter.

3. Final Answer:

   Right-click Region field and select 'Show Filter' -> Option D

4. Quick Check:

   Add quick filter = Right-click + Show Filter [OK]

Hint: Right-click field, choose 'Show Filter' to add quick filter [OK]

Common Mistakes:

• Dragging field to Tooltip instead of filter shelf
• Trying to create filter via calculated field
• Double-clicking field expecting filter

3. Given a dashboard with a quick filter on Category set to only show 'Furniture' and 'Office Supplies', what will happen to the sales chart?

medium

A. It will show no data because filters hide all categories

B. It will display sales data only for Furniture and Office Supplies

C. It will display sales data for all categories

D. It will display sales data only for Technology

Solution

1. Step 1: Understand quick filter effect on dashboard

   Quick filters limit data shown to selected values, here 'Furniture' and 'Office Supplies'.

2. Step 2: Predict chart behavior

   The sales chart updates to show only filtered categories, excluding others like Technology.

3. Final Answer:

   It will display sales data only for Furniture and Office Supplies -> Option B

4. Quick Check:

   Quick filter limits data shown = filtered categories only [OK]

Hint: Quick filters show only selected data in charts [OK]

Common Mistakes:

• Assuming filter does not affect charts
• Thinking filter hides all data
• Confusing filtered categories with unselected ones

4. You added a quick filter on Region, but it does not appear on the dashboard. What is the most likely cause?

medium

A. Quick filters only work on numeric fields

B. The Region field is not in the data source

C. The filter is hidden in the dashboard layout

D. You forgot to publish the dashboard

Solution

1. Step 1: Check common reasons for missing quick filters

   Filters can be added but hidden if dashboard layout hides them or they are collapsed.

2. Step 2: Evaluate other options

   Region is usually categorical and must exist; publishing does not affect local view; quick filters work on categorical fields too.

3. Final Answer:

   The filter is hidden in the dashboard layout -> Option C

4. Quick Check:

   Missing filter = hidden in layout [OK]

Hint: Check dashboard layout for hidden filters [OK]

Common Mistakes:

• Assuming quick filters only work on numbers
• Thinking publishing affects filter visibility
• Ignoring dashboard layout hiding filters

5. You want to create a dashboard where users can filter sales by Year using a slider and by Category using checkboxes. How should you configure the quick filters?

hard

A. Set Year filter to 'Range Slider' and Category filter to 'Multiple Values (list)'

B. Set both filters to 'Single Value Dropdown'

C. Set Year filter to 'Single Value Slider' and Category filter to 'Range Slider'

D. Set Year filter to 'Multiple Values (list)' and Category filter to 'Single Value Dropdown'

Solution

1. Step 1: Choose filter type for Year

   Years are numeric and ordered, so a 'Range Slider' lets users pick a range easily.

2. Step 2: Choose filter type for Category

   Categories are discrete values; 'Multiple Values (list)' shows checkboxes for multiple selections.

3. Final Answer:

   Set Year filter to 'Range Slider' and Category filter to 'Multiple Values (list)' -> Option A

4. Quick Check:

   Year = slider, Category = checkboxes [OK]

Hint: Use slider for numeric, checkboxes for categorical filters [OK]

Common Mistakes:

• Using dropdowns for numeric year filter
• Using range slider for categorical data
• Confusing single vs multiple value filter types