Relative date filtering in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Relative Date Filters in Tableau

Which of the following best describes how a relative date filter works in Tableau?

A It filters data based on a fixed date range that never changes.

B It filters data only by specific years selected manually by the user.

C It filters data dynamically based on the current date, such as last 7 days or last month.

D It filters data by excluding weekends and holidays automatically.

💡 Hint

Think about how the filter updates when you open the dashboard tomorrow.

Relative date filters adjust automatically based on the current date, showing data like last 7 days or last month dynamically.

❓ dax_lod_result

intermediate

Result of Relative Date Filter Expression

Given a dataset with daily sales and today's date is 2024-06-15, what will be the total sales if a relative date filter is set to 'Last 3 days'?

Sales data:

• 2024-06-12: 100
• 2024-06-13: 150
• 2024-06-14: 200
• 2024-06-15: 250
• 2024-06-16: 300

A 600

B 550

C 650

D 700

💡 Hint

Remember 'Last 3 days' includes today and the two previous days.

The last 3 days including today (2024-06-15) are 2024-06-13, 2024-06-14, and 2024-06-15. Their sales sum to 150 + 200 + 250 = 600.

❓ visualization

advanced

Choosing the Correct Relative Date Filter Setup

You want to create a dashboard that always shows sales data for the last full calendar month (e.g., if today is June 15, show May 1 to May 31). Which relative date filter setting in Tableau will achieve this?

A Set filter to 'Last 3 months' including current month.

B Set filter to 'Last 30 days' including today.

C Set filter to 'This month' including today.

D Set filter to 'Previous month' with 'Include current period' unchecked.

💡 Hint

Think about how to exclude the current partial month and only show the full previous month.

'Previous month' filter excludes the current month and shows the entire last calendar month, which matches the requirement.

🔧 Formula Fix

advanced

Why Does the Relative Date Filter Not Update Correctly?

A Tableau user sets a relative date filter to 'Last 7 days' but notices the dashboard does not update daily and shows stale data. What is the most likely cause?

A The relative date filter only works with weekly data, not daily data.

B The data source is not set to refresh daily, so the filter uses old data.

C The filter was set to 'Fixed date' instead of 'Relative date'.

D The dashboard is missing a date field in the view.

💡 Hint

Consider what controls the data freshness behind the scenes.

If the data source is not refreshed daily, the relative date filter will show data based on the last refresh date, causing stale results.

🎯 Scenario

expert

Designing a Dynamic Sales Report with Multiple Relative Date Filters

You need to build a Tableau report that shows three sales metrics side by side:

• Sales for the last 7 days
• Sales for the last full calendar month
• Sales for the last 3 full calendar months

Which approach will correctly implement these relative date filters so all metrics update dynamically and independently?

A Create three separate relative date filters on the same date field, each configured for the respective period, and apply each filter only to its corresponding metric using context filters or separate worksheets.

B Create one relative date filter set to 'Last 3 months' and use calculated fields to extract last 7 days and last month sales from it.

C Use a fixed date filter for last full calendar month and last 3 months, and a relative date filter only for last 7 days, applying all filters globally.

D Create a parameter to select the date range and use it in a single relative date filter applied to all metrics.

💡 Hint

Think about how to isolate filters so they don't interfere with each other.

Using separate relative date filters applied only to their respective metrics ensures each metric updates correctly and independently.

Practice

1. What does a Relative Date filter in Tableau do?

easy

A. It filters data based on fixed dates you manually select.

B. It shows data for a dynamic time period like last 7 days or this month.

C. It groups data by categories like product or region.

D. It sorts data alphabetically by date.

Solution

1. Step 1: Understand the purpose of Relative Date filter

   A Relative Date filter dynamically adjusts the data shown based on the current date, such as last 7 days or this month.

2. Step 2: Compare with other filter types

   Fixed date filters require manual date selection, unlike Relative Date filters which update automatically.

3. Final Answer:

   It shows data for a dynamic time period like last 7 days or this month. -> Option B

4. Quick Check:

   Relative Date filter = dynamic time period [OK]

Hint: Relative Date filters always adjust with today's date [OK]

Common Mistakes:

• Confusing Relative Date with fixed date filters
• Thinking it sorts data instead of filtering
• Assuming it groups data by categories

2. Which of the following is the correct way to apply a Relative Date filter in Tableau?

easy

A. Drag a date field to Filters, choose 'Relative Date', then select the desired period.

B. Drag a measure to Filters and select 'Relative Date'.

C. Right-click a dimension and select 'Sort by Relative Date'.

D. Create a calculated field with TODAY() and filter manually.

Solution

1. Step 1: Identify how to apply Relative Date filter

   In Tableau, you drag a date field to the Filters shelf and then choose 'Relative Date' to set dynamic periods.

2. Step 2: Eliminate incorrect options

   Measures cannot be filtered by Relative Date, sorting is different, and manual calculated fields are not the standard method.

3. Final Answer:

   Drag a date field to Filters, choose 'Relative Date', then select the desired period. -> Option A

4. Quick Check:

   Apply Relative Date filter via date field in Filters [OK]

Hint: Always start with a date field for Relative Date filters [OK]

Common Mistakes:

• Trying to apply Relative Date on measures
• Confusing sorting with filtering
• Using manual calculated fields unnecessarily

3. Given today's date is 2024-06-15, what data will be shown if you apply a Relative Date filter for 'Last 7 days' on a sales date field?

medium

A. Sales data from 2024-06-01 to 2024-06-07 inclusive.

B. Sales data from 2024-06-15 only.

C. Sales data from 2024-06-08 to 2024-06-14 inclusive.

D. Sales data from 2024-06-09 to 2024-06-15 inclusive.

Solution

1. Step 1: Understand 'Last 7 days' relative to today

   'Last 7 days' means the past 7 days including today.

2. Step 2: Calculate the date range

   From 2024-06-15, last 7 days are 2024-06-09 through 2024-06-15 inclusive.

3. Final Answer:

   Sales data from 2024-06-09 to 2024-06-15 inclusive. -> Option D

4. Quick Check:

   Last 7 days includes today, from today back 6 days [OK]

Hint: Last 7 days includes today, 7 days ending today [OK]

Common Mistakes:

• Excluding today's date mistakenly
• Counting from beginning of month
• Confusing with previous full week

4. You applied a Relative Date filter for 'This Month' but your dashboard shows no data. What is the most likely cause?

medium

A. The filter was set to 'Last Year' instead of 'This Month'.

B. You applied the filter on a non-date field.

C. The date field has no data for the current month.

D. The data source is disconnected.

Solution

1. Step 1: Check data availability for current month

   If no data exists for the current month, the 'This Month' filter will show no results.

2. Step 2: Consider other causes but focus on data

   Applying filter on non-date fields or wrong filter choice would cause errors or different results; disconnected data source usually causes errors, not empty data.

3. Final Answer:

   The date field has no data for the current month. -> Option C

4. Quick Check:

   No data in current month = empty 'This Month' filter result [OK]

Hint: Check if data exists for the filtered period first [OK]

Common Mistakes:

• Assuming filter syntax error without checking data
• Ignoring data source connection status
• Confusing filter period with applied filter

5. You want to create a dashboard that always shows sales data for the last 30 days but excludes today. Which Relative Date filter setting should you use?

hard

A. Set filter to 'Last 30 days' excluding today.

B. Set filter to 'Last 31 days' including today.

C. Set filter to 'This Month' and manually exclude today.

D. Set filter to 'Last 30 days' including today.

Solution

1. Step 1: Understand requirement to exclude today

   The filter must show the 30 days before today, not including today itself.

2. Step 2: Choose correct Relative Date filter option

   'Last 30 days' excluding today matches the requirement exactly; including today or using 'This Month' won't exclude today properly.

3. Final Answer:

   Set filter to 'Last 30 days' excluding today. -> Option A

4. Quick Check:

   Exclude today by choosing 'Last 30 days' without today [OK]

Hint: Use 'Last 30 days' excluding today for past 30 full days [OK]

Common Mistakes:

• Including today when it should be excluded
• Using 'This Month' which varies in length
• Adding extra days unnecessarily