Relative date filtering in Tableau - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is relative date filtering in Tableau?

Relative date filtering lets you filter data based on dates relative to today, like last 7 days or next 3 months, without picking fixed dates.

beginner

How do you apply a relative date filter in Tableau?

Right-click a date field, choose 'Filter', then select 'Relative date'. Pick options like last, next, or this, and set the time unit (days, weeks, months).

beginner

Why use relative date filters instead of fixed date filters?

Relative date filters update automatically as time passes, so your dashboard always shows recent or upcoming data without manual changes.

beginner

Can you filter data for the last 30 days using relative date filtering in Tableau?

Yes, select 'Last' and '30' days in the relative date filter to always show data from the past 30 days up to today.

beginner

What happens if you set a relative date filter to 'Next 1 month'?

Tableau will show data from today up to one month in the future, updating daily as the current date changes.

Which option lets you filter data for the last 7 days in Tableau?

A Range filter with fixed dates

B Fixed date filter from 7 days ago to today

C Top N filter with 7 days

D Relative date filter with 'Last' 7 days

Relative date filter with 'Last' 7 days automatically updates to always show the most recent 7 days.

What does a relative date filter set to 'This month' show?

A Data from today only

B All data from the current calendar month

C Data from the previous month

D Data from the last 30 days

'This month' shows all data within the current calendar month.

How often does a relative date filter update its data range?

A Automatically every time the data or dashboard refreshes

B Only when you manually change the filter

C Once a month

D Never

Relative date filters update automatically with each data or dashboard refresh to keep the date range current.

Can you use relative date filtering to show data for the next 3 weeks?

A Yes, but only for days, not weeks

B No, relative date filters only work for past dates

C Yes, by selecting 'Next' and '3' weeks

D No, you must use fixed date filters

Relative date filters support future dates by choosing 'Next' and the number of weeks.

What is a benefit of using relative date filters in dashboards?

A They keep the data current without manual updates

B They require manual date entry each time

C They only work with yearly data

D They slow down dashboard performance

Relative date filters automatically adjust to show current data ranges, reducing manual work.

Explain how relative date filtering works in Tableau and why it is useful.

Think about how you might want to see recent sales or upcoming events without changing filters every day.

Describe the steps to apply a relative date filter to show the last 30 days of data in Tableau.

Remember the menu path and the options you select for relative date filtering.