(v24) Set a Time Field Filter

Set a Time Field Filter

This applies to: Visual Data Discovery

When you select a time attribute for a visual or filter snippet, you can filter the time range you display.

Note: If you are using a field that has time zone information disabled (select Not Specified), only the time-related information is shown in the user interface and exported with your data. Time zone labels are not included.

Set a time range for a time field filter

1. Select the filter icon on the visual, filter snippet, or dashboard to access the appropriate filter sidebar.

   • To access the filter sidebar, select its filter icon () or select Settings from the menu () and then select on the sidebar menu.

   • To access the dashboard filter sidebar, select its filter icon (). The dashboard-level filter icon is available only when all the visuals are from the same data source.

   The Filters sidebar appears showing any filters that have been applied. Select Add Filter if no filters are defined.

2. Select the Row tab. If the style of your visual is an arc gauge, KPI chart, table (raw data), histogram, or map markers chart, the Group tab is available, but you cannot create a group filter because all filters for these visual styles are row-level filters. If you are using the dashboard filters sidebar, the Group tab is not available.

   The Saved tab shows saved filters that you can apply to a dashboard or visual. See Maintain Saved Filters.

3. On the Row tab, select a time field you want to use from the list of available time fields. A second page with two tabs appears in the Filters sidebar: Range and Keyset.

   You can also select to access the Derived Field Editor or the Custom Metrics Editor to create or modify derived fields and custom metrics to be used as filters. See Access the Derived Field Editor from the Filters Sidebar and Access the Custom Metrics Editor from the Filters Sidebar.

4. On the Range tab, you can optionally apply a null filter to the full time range. Select an Operator option as needed:

   • Apply Is not NULL to hide null values

   • Apply Is NULL to include only null values

   • Apply Between to specify a time range

   

5. If you did not apply a Null filter, you can use the From and To boxes to specify the time range for the filter. You can set the range in static time or dynamic time, or use preset ranges provided.

   • Select Static Time or Dynamic Time in the fx drop-down menu.

     

     If you select Static Time, the From and To boxes are filled with default dates and times. Use the boxes to select specific from and to times:

     

     If you select Dynamic Time, the From and To boxes are filled with Start of Data Set and End of Data Set automatically. Use the Condition boxes to select different dynamic from and to times:

     

   • Alternatively, select Presets to fill the From and To boxes with predefined time ranges provided.

     

     Use the filter box at the top of the presets list to locate the preset setting you want. Descriptions of each of the preset options are provided in Preset Time Ranges.

6. Alternatively, select a keyset on the Keysets tab to use for the filter. See Use Keysets.

7. After the filter specifics have been defined, select Continue. If you create the filter at the dashboard level, it is applied to all the visuals and filter snippets in the dashboard. Otherwise, it is applied only to the selected (active) visual or filter snippet. After confirming your changes, select Apply.