Date Filters
Date filters let you filter your results by a specific date, custom date, or dynamic date range you choose. For example, you can select a dynamic date like today, which updates when the workbook runs. You can only apply one date filter per workbook visualization.
Date filters are available in date fields and work with all workbook visualizations (charts, pivot tables, and table views).
To apply a date filter to a workbook visualization:
-
Click the Field Menu icon
in the Dataset Panel or Layout Panel next to a date field and select Filter Date> Advanced... -
In the Filter Date (Advanced...) window, use the Specific Dates tab to enter a custom date or the Date Ranges tab to select a dynamic date. Use the Values tab to select specific dates from the underlying dataset query results.
-
Click Apply.
The workbook visualization automatically updates the results.
The results are updated and the selected filter criteria is displayed above the Viewer.