Quick filters for interactivity in Tableau - Cell-by-Cell Formula Trace

Concept Flow

Region  Sales
East    1000
West    1500
North   1200
South   1300

Quick filter applies condition:
[Region] = "East" OR [Region] = "West"

Filtered result:
East    1000
West    1500

This flow shows the original sales data by region and how the quick filter selects only East and West regions for display.

Formula

[Region] = "East" OR [Region] = "West"

This Tableau filter expression selects rows where the Region is either East or West.

Step-by-Step Trace

Step	Expression	Evaluates To	Explanation
1	[Region] = "East"	[True, False, False, False]	Check each row if Region equals "East". Only row 1 matches.
2	[Region] = "West"	[False, True, False, False]	Check each row if Region equals "West". Only row 2 matches.
3	[Region] = "East" OR [Region] = "West"	[True, True, False, False]	Combine both conditions with OR to include rows where Region is East or West.
4	FILTER([Region], [Region] = "East" OR [Region] = "West")	["East", "West"]	Filter the Region column to only include East and West regions.

The filter returns only rows where Region is East or West, enabling interactive data selection.

Variable Tracker

Variable	Value
[Region]	["East", "West", "North", "South"]
[Region] = "East"	[True, False, False, False]
[Region] = "West"	[False, True, False, False]
[Region] = "East" OR [Region] = "West"	[True, True, False, False]
FILTER result	["East", "West"]

Key Moments

What does the filter condition "[Region] = "East" OR [Region] = "West"" do?

Which rows are included after applying the quick filter?

Why use quick filters in Tableau?

Sheet Trace Quiz - 1 Questions

Which regions remain visible after applying the quick filter?

A East and West

B North and South

C All regions

D No regions

Key Result

Quick filters in Tableau use logical conditions to dynamically show only rows matching user-selected criteria, improving interactivity.

Transcript

We start with sales data by region. The quick filter uses the condition "[Region] = \"East\" OR [Region] = \"West\"" to check each row. Rows matching East or West return True and are kept. Others are hidden. This lets users focus on specific data interactively.