Date filters in Tableau - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a date filter in Tableau?

A date filter in Tableau lets you choose which dates to include or exclude in your view. It helps focus on specific time periods like months, years, or custom ranges.

beginner

How do you create a relative date filter in Tableau?

You drag a date field to the Filters shelf, select 'Relative Date', then choose options like last 7 days, last month, or next year to filter dynamically based on today's date.

intermediate

What is the difference between a continuous and discrete date filter?

Continuous date filters treat dates as a timeline and allow filtering by ranges (like from Jan to Mar). Discrete date filters treat dates as separate categories (like specific months or years).

intermediate

Why use a date range filter instead of a relative date filter?

A date range filter lets you pick exact start and end dates manually, useful when you want a fixed period. A relative date filter changes automatically based on the current date.

beginner

How can you make a date filter user-friendly in a Tableau dashboard?

Add a date filter as a quick filter with a calendar picker or slider. This lets users easily select dates without typing, improving interaction and clarity.

Which Tableau filter type updates automatically based on today's date?

A Relative Date Filter

B Date Range Filter

C Discrete Date Filter

D Continuous Date Filter

Relative Date Filters adjust dynamically based on the current date, like showing the last 30 days.

What does a continuous date filter allow you to do?

A Exclude weekends automatically

B Select specific date categories like months

C Filter only by year

D Filter by a range of dates on a timeline

Continuous date filters treat dates as a timeline and allow filtering by ranges.

How do you add a date filter to a Tableau dashboard for user interaction?

A Drag date field to Filters shelf and show filter

B Write a calculated field

C Use a parameter only

D Create a new worksheet

Dragging the date field to Filters shelf and showing the filter adds an interactive date filter to the dashboard.

Which filter type treats dates as separate categories?

A Continuous Date Filter

B Relative Date Filter

C Discrete Date Filter

D Date Range Filter

Discrete date filters treat dates as separate categories like months or years.

When would you use a date range filter instead of a relative date filter?

A When excluding weekends

B When you want a fixed start and end date

C When filtering by year only

D When you want the filter to update daily

Date range filters let you pick fixed start and end dates manually.

Explain how to create and use a relative date filter in Tableau.

Think about filtering data based on today's date.

Describe the difference between continuous and discrete date filters and when to use each.

Consider how Tableau groups or treats dates in each filter.