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.
