Date filters in Tableau - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants to see sales data filtered by specific date ranges to understand performance in different periods.

📊 Data: You have sales transaction data including Order Date, Product Category, Sales Amount, and Region.

🎯 Deliverable: Create a Tableau dashboard with date filters that allow the manager to select sales data by Year, Quarter, and a custom date range.

Sample Data

Order Date	Product Category	Sales Amount	Region
2023-01-15	Electronics	1200	North
2023-02-20	Furniture	850	East
2023-03-05	Office Supplies	400	South
2023-04-10	Electronics	1500	West
2023-05-18	Furniture	700	North
2023-06-25	Office Supplies	300	East
2023-07-30	Electronics	1300	South
2023-08-15	Furniture	900	West
2023-09-10	Office Supplies	450	North
2023-10-05	Electronics	1600	East
2023-11-20	Furniture	750	South
2023-12-15	Office Supplies	500	West

1

Step 1: Connect Tableau to the sales data source containing Order Date, Product Category, Sales Amount, and Region.

No formula needed; just connect the data source.

Expected Result

Tableau shows the data fields ready for analysis.

2

Step 2: Create a new worksheet and drag 'Order Date' to the Columns shelf and 'Sales Amount' to the Rows shelf.

Use SUM([Sales Amount]) aggregation.

Expected Result

A basic line chart showing total sales over time by Order Date.

3

Step 3: Add a date filter for 'Order Date' by dragging it to the Filters shelf and selecting 'Years' to filter by year.

Filter on 'Order Date' by Year.

Expected Result

Filter control appears allowing selection of specific years.

4

Step 4: Add another date filter for 'Order Date' to filter by Quarter.

Filter on 'Order Date' by Quarter.

Expected Result

Filter control appears allowing selection of specific quarters.

5

Step 5: Add a relative date filter for 'Order Date' to allow custom date range selection.

Use 'Relative Date' filter option on 'Order Date'.

Expected Result

Filter control appears allowing the manager to select custom date ranges.

6

Step 6: Show all three date filters (Year, Quarter, Custom Range) on the dashboard for interactive filtering.

Add filters to dashboard and set to 'Show Filter'.

Expected Result

Dashboard has interactive date filters that update sales chart dynamically.

Final Result

Sales Dashboard

[Year Filter] [Quarter Filter] [Custom Date Range Filter]

  Sales Amount
    |
1600|       *        *
1400|    *     *        
1200| *                 *
1000|                    
 800|      *      *      
 600|                    
 400|  *           *     
 200|                    
    +-----------------------> Order Date

Filters let you pick year, quarter, or any date range to see sales trends.

✓Sales vary by quarter, with peaks in Q1 and Q4.

✓Electronics sales are highest in Q4.

✓Furniture sales are steady but lower in mid-year.

✓Custom date filters help focus on specific periods for detailed analysis.

Bonus Challenge

Add a filter to select sales by Region along with the date filters to analyze sales trends by location.

Show Hint

Drag 'Region' to Filters shelf and show filter on dashboard; combine with date filters for multi-dimensional filtering.

Practice

1. What is the main purpose of using Date filters in Tableau dashboards?

easy

A. To create new date columns

B. To change the color of date fields

C. To focus analysis on specific time periods

D. To sort data alphabetically

Solution

1. Step 1: Understand what date filters do

   Date filters allow you to limit data shown based on dates, focusing on certain time frames.

2. Step 2: Identify the correct purpose

   Among the options, only focusing analysis on specific time periods matches the use of date filters.

3. Final Answer:

   To focus analysis on specific time periods -> Option C

4. Quick Check:

   Date filters = focus on time periods [OK]

Hint: Date filters narrow data by time to focus analysis [OK]

Common Mistakes:

• Confusing filters with formatting options
• Thinking filters create new data columns
• Assuming filters sort data alphabetically

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

easy

A. Right-click date field > Filter > Select 'Relative Date'

B. Drag date field to Columns shelf only

C. Create a calculated field with TODAY()

D. Use Data Source tab to filter dates

Solution

1. Step 1: Recall how to add relative date filters

   In Tableau, you right-click the date field, choose Filter, then select 'Relative Date' to add this filter type.

2. Step 2: Check other options

   Dragging to Columns shelf or creating calculated fields does not add a relative date filter directly. Data Source tab filters are different.

3. Final Answer:

   Right-click date field > Filter > Select 'Relative Date' -> Option A

4. Quick Check:

   Relative date filter = right-click > Filter > Relative Date [OK]

Hint: Right-click date field to add relative date filter quickly [OK]

Common Mistakes:

• Dragging date to Columns shelf does not filter
• Using calculated fields instead of filter dialog
• Trying to filter dates in Data Source tab only

3. Given a relative date filter set to 'Last 3 months' on a dashboard viewed on June 15, 2024, which months' data will be shown?

medium

A. March, April, May 2024

B. April, May, June 2024

C. February, March, April 2024

D. May, June, July 2024

Solution

1. Step 1: Understand 'Last 3 months' relative filter

   This filter includes the current month and the two previous months.

2. Step 2: Identify months for June 15, 2024

   Current month is June 2024, so last 3 months are April, May, and June 2024.

3. Final Answer:

   April, May, June 2024 -> Option B

4. Quick Check:

   Last 3 months includes current month [OK]

Hint: Relative filters include current month plus previous months [OK]

Common Mistakes:

• Excluding current month from last 3 months
• Counting future months incorrectly
• Confusing calendar months with weeks

4. You applied a relative date filter for 'Last 7 days' but the dashboard shows no data. What is the most likely cause?

medium

A. Date field is not recognized as a date type

B. Dashboard is not refreshed

C. Filter was applied on a non-date field

D. Data source has no records in the last 7 days

Solution

1. Step 1: Check filter logic

   If the filter is set correctly but no data shows, it likely means no data exists in that date range.

2. Step 2: Evaluate other options

   Incorrect data type or wrong field would cause errors, not empty results. Dashboard refresh issues usually show old data, not empty.

3. Final Answer:

   Data source has no records in the last 7 days -> Option D

4. Quick Check:

   No data in filter range = empty dashboard [OK]

Hint: Check data availability before blaming filter setup [OK]

Common Mistakes:

• Assuming filter syntax error causes empty data
• Not verifying data freshness
• Confusing data type errors with empty results

5. You want a dashboard that always shows sales data for the current quarter and updates automatically each day. Which filter type should you use in Tableau?

hard

A. Relative date filter set to 'This quarter'

B. Range date filter with fixed start and end dates

C. Individual date filter selecting specific dates

D. Top N filter on sales amount

Solution

1. Step 1: Identify filter that updates automatically

   Relative date filters update dynamically based on current date, perfect for current quarter data.

2. Step 2: Compare with other filter types

   Range filters with fixed dates do not update automatically. Individual date filters are static. Top N filters are unrelated to dates.

3. Final Answer:

   Relative date filter set to 'This quarter' -> Option A

4. Quick Check:

   Dynamic quarter data = relative date filter [OK]

Hint: Use relative date filters for auto-updating time frames [OK]

Common Mistakes:

• Using fixed range filters expecting auto-update
• Selecting individual dates manually
• Confusing sales amount filters with date filters