Context filters in Tableau - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants to analyze sales performance for the top 3 product categories by sales revenue in the last year. They want to see monthly sales trends only for these top categories.

📊 Data: You have sales data including Order Date, Product Category, Sales Revenue, and Quantity Sold for the past two years.

🎯 Deliverable: Create a Tableau dashboard showing monthly sales trends for the top 3 product categories by sales revenue in the last year using context filters.

Sample Data

Order Date	Product Category	Sales Revenue	Quantity Sold
2023-01-15	Electronics	1200	5
2023-01-20	Furniture	800	3
2023-02-10	Office Supplies	400	10
2023-02-15	Electronics	1500	7
2023-03-05	Furniture	900	4
2023-03-10	Office Supplies	450	12
2023-04-12	Electronics	1300	6
2023-04-18	Furniture	850	3
2023-05-20	Office Supplies	500	15
2023-05-25	Electronics	1400	7
2023-06-15	Furniture	950	5
2023-06-20	Office Supplies	480	14

1

Step 1: Connect your sales data source to Tableau and load the data.

No formula needed; just connect and import the data.

Expected Result

Sales data with Order Date, Product Category, Sales Revenue, and Quantity Sold is loaded into Tableau.

2

Step 2: Create a calculated field to extract the year from Order Date to filter last year's data.

YEAR([Order Date])

Expected Result

A new field 'Year' is available to filter data for the last year (2023).

3

Step 3: Apply a filter on 'Year' to include only 2023 data.

Filter: Year = 2023

Expected Result

Data is filtered to only include sales from the year 2023.

4

Step 4: Create a context filter on Product Category to keep only the top 3 categories by total sales revenue in 2023.

Right-click Product Category filter > Add to Context > Set filter to Top 3 by SUM([Sales Revenue])

Expected Result

Context filter applied; only top 3 product categories by sales revenue in 2023 are included in further analysis.

5

Step 5: Create a line chart with Order Date (month) on Columns and SUM(Sales Revenue) on Rows, colored by Product Category.

Columns: MONTH([Order Date]) Rows: SUM([Sales Revenue]) Color: Product Category

Expected Result

Line chart shows monthly sales trends for the top 3 product categories in 2023.

6

Step 6: Build a dashboard and add the line chart. Add filters for Year and Product Category with context filter applied.

Drag worksheet to dashboard; add Year and Product Category filters; ensure Product Category filter is context filter.

Expected Result

Dashboard displays monthly sales trends for top 3 categories with filters working correctly.

Final Result

Monthly Sales Trends Dashboard

+------------------------------------------------+
| Month | Electronics | Furniture | Office Supplies |
|------------------------------------------------|
| Jan   | 1200       | 800       | 0              |
| Feb   | 1500       | 0         | 400            |
| Mar   | 0          | 900       | 450            |
| Apr   | 1300       | 850       | 0              |
| May   | 1400       | 0         | 500            |
| Jun   | 0          | 950       | 480            |
+------------------------------------------------+

(Line chart with lines for each category showing trends over months)

✓Electronics, Furniture, and Office Supplies are the top 3 product categories by sales revenue in 2023.

✓Electronics shows strong sales in January, February, April, and May.

✓Furniture sales peak in March and June.

✓Office Supplies have steady sales in February, March, May, and June.

Bonus Challenge

Add a parameter to let users select how many top product categories to analyze (e.g., top 2, top 3, top 5) and update the context filter dynamically.

Show Hint

Create a parameter for number of top categories, then use a calculated field with RANK() function on SUM([Sales Revenue]) to filter categories based on the parameter value.

Practice

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

easy

A. To export data to Excel

B. To change the color scheme of the dashboard

C. To create calculated fields

D. To set the base data for other filters to work on

Solution

1. Step 1: Understand the role of context filters

   Context filters define a subset of data that other filters use as their starting point.

2. Step 2: Compare with other options

   Changing colors, exporting data, or creating calculated fields are unrelated to context filters.

3. Final Answer:

   To set the base data for other filters to work on -> Option D

4. Quick Check:

   Context filter = base data filter [OK]

Hint: Context filters set base data before other filters apply [OK]

Common Mistakes:

• Thinking context filters change visuals directly
• Confusing context filters with calculated fields
• Assuming context filters export data

2. Which of the following is the correct way to add a filter to context in Tableau?

easy

A. Right-click the filter and select 'Add to Context'

B. Double-click the filter and select 'Add to Context'

C. Drag the filter to the color shelf

D. Right-click the filter and select 'Remove from Context'

Solution

1. Step 1: Identify the correct action to add a filter to context

   In Tableau, you add a filter to context by right-clicking it and choosing 'Add to Context'.

2. Step 2: Eliminate incorrect options

   Double-clicking or dragging to color shelf does not add to context; 'Remove from Context' is the opposite action.

3. Final Answer:

   Right-click the filter and select 'Add to Context' -> Option A

4. Quick Check:

   Add to Context = Right-click + Add to Context [OK]

Hint: Right-click filter, choose 'Add to Context' to set context filter [OK]

Common Mistakes:

• Double-clicking instead of right-clicking
• Dragging filter to color shelf
• Confusing 'Add to Context' with 'Remove from Context'

3. Consider a Tableau dashboard with two filters: Filter A is a context filter filtering Region = 'West', and Filter B filters Category = 'Furniture'. What data will Filter B apply to?

medium

A. Only data where Region = 'West'

B. All data ignoring Filter A

C. Data where Region = 'West' and Category = 'Furniture' combined

D. Only data where Category = 'Furniture' regardless of Region

Solution

1. Step 1: Understand context filter effect

   Filter A as a context filter sets the base data to Region = 'West'.

2. Step 2: Apply Filter B on context data

   Filter B applies only on the data already filtered by Filter A, so it filters further by Category = 'Furniture'.

3. Final Answer:

   Data where Region = 'West' and Category = 'Furniture' combined -> Option C

4. Quick Check:

   Filter B applies on context filter data and further filters it [OK]

Hint: Filter B works on data filtered by context filter A and further filters it [OK]

Common Mistakes:

• Thinking Filter B ignores context filter
• Assuming filters apply independently
• Confusing combined filter logic

4. You added a filter to context but notice your dashboard performance worsened. What is a likely cause?

medium

A. Context filters always speed up dashboards

B. Context filters create a temporary table which can slow queries if large

C. You forgot to refresh the data source

D. Filters outside context are ignored

Solution

1. Step 1: Understand context filter mechanics

   Context filters create a temporary table to speed up dependent filters but can slow down if the temporary table is large.

2. Step 2: Analyze performance impact

   If the context filter results in a large temporary table, query performance can degrade.

3. Final Answer:

   Context filters create a temporary table which can slow queries if large -> Option B

4. Quick Check:

   Large context tables can slow performance [OK]

Hint: Large context filter sets can slow dashboard performance [OK]

Common Mistakes:

• Assuming context filters always improve speed
• Ignoring data source refresh
• Believing filters outside context are ignored

5. You want to calculate the percentage of sales for a selected category but only within a specific region. How can context filters help you achieve this correctly in Tableau?

hard

A. Add the region filter to context so percentage calculations consider only that region

B. Add the category filter to context and ignore region filters

C. Use context filters to change the color of the sales bars

D. Apply both filters without context to get correct percentages

Solution

1. Step 1: Identify calculation scope

   Percentage of sales within a region requires filtering data first by region.

2. Step 2: Use context filter for region

   Adding the region filter to context sets the base data for percentage calculations to that region only.

3. Step 3: Apply category filter normally

   The category filter then works on the region-filtered data, giving correct percentages.

4. Final Answer:

   Add the region filter to context so percentage calculations consider only that region -> Option A

5. Quick Check:

   Context filter sets calculation base [OK]

Hint: Put region filter in context for correct percentage calculations [OK]

Common Mistakes:

• Putting category filter in context instead of region
• Ignoring context filters for calculations
• Assuming filters without context calculate correctly