Relative Date Filters in Tableau

      Relative Date Filters

                        Create filters to show a date period that updates depending on when you open the view. For example, create dynamic filters to only show this week, year to date, the past few days, and so on. Relative date filters minimize the time spent updating workbooks and make it easier to create lasting views that you can publish and share.

Drag a date field from the Data pane and drop it on the Filters shelf.

 

1.In the Filter Field dialog box, select Relative date and then click Next.

Drag a field from the Data window to the Filter shelf and select Relative to Now in the Filter Field dialog box.

                                    

2.Select a Time Unit

The Filter dialog box opens showing the Relative to Now options. Select a unit of time to filter by. For example, to filter to show the last 2 quarters, select Quarters as the time unit.

3.Define the Date Period

Select an option on the right to define the date period. Select from a variety of options including current, previous, next. When finished, click OK

Use the rest of the controls to define the date filter. You can select from a variety of common options including current, previous, and next. By default, the filter is relative to today. To make the filter relative to an alternate date, select the Anchor relative to option in the bottom left corner and select the date to anchor to.

4.When finished, click OK.

We have so many filters are there Create filtering to show a date period that updates depending on when you open different kinds of filters is there.