📅Date picker in filters

Explore the Date picker in filters to easily select ranges, build custom time slices, and compare periods with an intuitive, redesigned calendar and time slicer.

Why time slices?

With our custom time slice picker, you can visualize data for different time slices (e.g., calculate percentage change or absolute change). These time slices can either be 3 weeks over 3 weeks change or last 3 weeks compared to the same 3 weeks last year. Support for such custom time ranges allows users to define their own Time Period and compare the data for different time frames as required. Also, scroll down to know how to customize the calendar view.

Where to find the time slices?

Time slices can be created for any date range filter under Explore and Discover tabs.

In Release 4.0, the date picker has been dramatically redesigned to enhance the user experience.

Date picker under Explore tab

When you filter using a date-based column, the following window appears:

Date picker window

1. The left pane Pick Time Period displays a list of pre-defined date ranges. Select the required date range.

2. The Time Period displays the exact ‘From’ and ‘To’ dates in MM/DD/YYYY format.

3. The corresponding range will be highlighted accordingly and displayed on the calendar.

If you select any of the preset date ranges from Pick Time Period, you won’t be able to manually interact with the calendar or apply changes to the Time Period fields.

1. If you select Custom Date Range in the left pane, you can manually change the Time Period fields. Alternatively, you can interact with the calendar to select the required dates, and the Time Period fields will be updated accordingly.

Custom date range

1. Custom Time Slicer allows you to create a custom time period instead of date ranges.

2. Select Custom Time Slicer in the left pane; you can find another row of fields added under Time Period.

3. Click on each field to view the corresponding dropdown list, where you can select the required time slice. The dates on the calendar will be highlighted accordingly.

4. Using Custom Time Slicer, you can select previous/next ‘n’ number of days/weeks/months/quarters/years that exist in this/last/last to last year.

Custom time slicer

1. Below the calendar, you can find the following details:

• Available dates: The available date range according to the selected Business View.

• Last refresh: The date on which the dataset from the Business View was last refreshed.

• Current date: The current system date.

Date picker window in action