For relative filters for time, Tableau gives me 2 options:
1. to select current month(m) and last 2 months OR
2. to select current month(m) and next 2 months
But I need a filter from (m-2) to (m+2). How do i set such a relative filter on time?
Example: If the current month is Feb, I need the filter from Dec to April
You can create a calculation like this:
DATEADD( 'month', -2, DATETRUNC( 'month', [your_date] ) )
and use it as a Relative Date filter, setting it to show Last 5 Months.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...