Is there a way to dynamically show the last 'x' days and next 'x' days on the same worksheet? When I filter on date, I only see the option to show either 'Last' or 'Next'. I'm looking to get the last 5 days and next 1 day from the current Day. My data is updated daily on Tableau Server. Thank you!
Add a parameter called paramx, set it's type as integer.
Drag your date onto the filter, select 'Individual Dates'. Click the condition tab and enter the following formula: [Your Date]>= DATEADD('day',[paramx]*-1,TODAY()) and [Your Date]<= DATEADD('day',[paramx],TODAY())