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.