How-to | Explore date columns with interactive date ranges #

To explore and filter a preview of a dataset with interactive date ranges:

  1. Click the dropdown arrow of a date column .

  2. Select Filter .

The interactive filter allows you to view a subset of the dataset filtered on an exact date and time range , and enter the range values according to your preferred time zone.

../../_images/interactive-date-filter.png

In addition, the filter allows you to filter on a relative range or a date part .

To filter on a relative range:

  1. Simply click the Filter on dropdown.

  2. Select Relative range .

By default, the Year date part is selected. The filter displays relative range options such as This Year , Last X Year(s) , and Next X Year(s) . You can change the date part and the length of the selected period. For example, you can choose to display rows from the last 9 months, as shown below.

../../_images/relative-date-range.png

To filter on a date part:

  1. Click the Filter on dropdown.

  2. Select Date part .

  3. Change the default date part filtering from Year to another date part, for example Month of year .

The number of rows for each date part (in this case, month) is also displayed next to the date part options, between parenthesis.

../../_images/date-part.png

This type of filtering can be useful to get a quick overview of the number of rows in a given recurring period. In the example shown above, which is using flight reviews data, we choose to display only the reviews submitted in December to see how the busy holiday season impacts travellers’ flying experience.