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.