Date Filters

Date filters provide specialized filtering for temporal data with options for relative dates, date ranges, and discrete date parts. They support rolling time periods, such as "Last 30 Days" or "Current Quarter," which automatically update. Date filters can be configured for specific dates, ranges, or relative periods. They're essential for time-series analysis and trend reporting.

To create a date filter, perform the following steps.

1. Using the Kyvos OrderDate dataset, drag OrderDate to Filters.

2. To select the filter type, choose Relative Date.

   Open

   

3. Set to Last 15 Years.

   Open

   

4. Click Ok.

5. Drag OrderDate to columns (Discrete), drill down to the quarters, and drag quarters to rows.

6. Drag Sum Sales to text.

7. Right-click the date filter > Show Filter.

   Open

   

8. Users can now adjust the relative date range.

   Open

   

9. Try changing to Years, Quarters, or Range of Dates for different filtering options