Date filters in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ dax_lod_result

intermediate

Calculate sales for the last 30 days using a date filter

You have a sales dataset with a [Order Date] field. Which DAX measure correctly calculates total sales for the last 30 days from today?

A TotalSalesLast30Days = CALCULATE(SUM(Sales[Amount]), FILTER(Sales, Sales[Order Date] <= TODAY() - 30))

B TotalSalesLast30Days = CALCULATE(SUM(Sales[Amount]), FILTER(Sales, Sales[Order Date] > TODAY() + 30))

C TotalSalesLast30Days = CALCULATE(SUM(Sales[Amount]), FILTER(Sales, Sales[Order Date] >= TODAY() - 30))

D TotalSalesLast30Days = CALCULATE(SUM(Sales[Amount]), FILTER(Sales, Sales[Order Date] < TODAY()))

💡 Hint

Think about filtering dates that are within the last 30 days, including today.

Option C correctly filters sales where the order date is greater than or equal to 30 days before today, capturing the last 30 days.

Option C filters future dates, which is incorrect.

Option C filters dates older than 30 days ago, excluding recent sales.

Option C filters dates before today but does not limit to 30 days.

❓ visualization

intermediate

Best practice for date filter in Tableau dashboard

You want to add a date filter to your Tableau dashboard that lets users select a range of dates easily. Which option is the best practice for this filter?

A Use a continuous date slider filter that allows users to select any date range.

B Use a text box where users type dates manually.

C Use a discrete date filter with only year values to limit options.

D Use a filter that only allows selecting a single fixed date.

💡 Hint

Think about user flexibility and ease of use for date selection.

Option A provides a continuous slider, which is intuitive and flexible for users to select any date range.

Option A limits selection to years only, which is less flexible.

Option A is error-prone and not user-friendly.

Option A restricts users to one date, limiting analysis.

🧠 Conceptual

advanced

Understanding relative date filters in Tableau

Which statement best describes how a relative date filter works in Tableau?

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

B It filters data based on a fixed date range set by the developer that does not change over time.

C It filters data by excluding weekends and holidays automatically.

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

💡 Hint

Think about filters that update automatically as time passes.

Relative date filters adjust dynamically based on the current date, allowing views like last 7 days or last month.

Option D describes fixed date filters.

Option D is manual year selection.

Option D is unrelated to relative date filtering.

🔧 Formula Fix

advanced

Identify the error in this Tableau date filter calculation

This calculated field is intended to filter sales from the last 90 days:

IF [Order Date] >= DATEADD('day', -90, TODAY()) THEN [Sales] ELSE 0 END

What is the problem with this calculation?

Tableau

IF [Order Date] >= DATEADD('day', -90, TODAY()) THEN [Sales] ELSE 0 END

A The calculation returns sales values but does not filter data; it should be used as a filter condition.

B The function TODAY() is not valid in Tableau; use NOW() instead.

C DATEADD cannot use negative numbers; it must be positive.

D The ELSE 0 part causes errors because sales cannot be zero.

💡 Hint

Think about the difference between calculated fields and filters in Tableau.

The calculation returns sales values or zero but does not filter the data itself. To filter, this logic should be used as a filter condition or boolean expression.

Option A is incorrect; TODAY() is valid in Tableau.

Option A is incorrect; DATEADD accepts negative values.

Option A is incorrect; ELSE 0 is valid but does not filter.

🎯 Scenario

expert

Designing a dashboard with multiple date filters affecting different charts

You have a Tableau dashboard with two charts: one shows monthly sales, the other shows daily customer visits. You want to add two date filters: one for selecting months affecting the sales chart, and one for selecting days affecting the visits chart. How should you configure the filters to avoid confusion and ensure correct filtering?

A Use a single date filter for both charts to keep the dashboard simple and synchronized.

B Use two separate date filters with different field scopes and apply each filter only to its related chart using filter actions or context filters.

C Use two date filters but apply both filters to all charts to ensure consistency.

D Use one date filter for the sales chart and a text input for the visits chart to allow manual date entry.

💡 Hint

Think about how filters can be scoped to specific worksheets in Tableau.

Option B is correct because it uses separate filters scoped to their respective charts, avoiding confusion and incorrect filtering.

Option B forces both charts to use the same date range, which may not fit their granularity.

Option B applies both filters to all charts, causing conflicts.

Option B mixes filter types and reduces usability.