Even Time Intervals

Even time intervals allow you to include all time groupings from your data source on a dashboard that have date or time data. You can select whether you want to display all time data, or just the data that returns a value. By default, time groups with a value of NULL (groups without any data) are not displayed.

Even time interval grouping is only available on dashboards that use a data source with date and time fields. It is also not available for raw data tables, KPI charts, or maps.

Even time intervals can be displayed in live mode and historical playback using the time bar. See Live Mode and Historical Playback.

Applying Even Time Intervals

To apply even time intervals to data on bar, box plot, donut, floating bubble, heat map, line, packed bubble, pie, scatter, tree map, and word cloud visuals:

  1. Edit a dashboard with one of these visual styles that uses a data source containing date or time fields.

  2. Select a time attribute for the visual Group (x-axis).

  3. Select the Time Granularity box on the x-axis.

  4. Slide Include Blanks on to request even time intervals. By default, the ability to show all values is disabled and only attributes with a value greater than NULL are displayed.

  5. Slide Include Blanks on to request even time intervals. By default, the ability to show all values is disabled and only attributes with a value greater than NULL are displayed.

    If this is a line chart, you can also select the Display null as zero check box to request that null values display as zeros on the chart:

The dashboard updates to include all values from the data source.

To apply even time intervals to data on pivot tables:

  1. Edit a dashboard with a pivot table that uses a data source containing date or time fields.

  2. If you are editing the visual in a dashboard, select Edit Visual from the visual drop-down menu. The sidebar menu for the visual appears.

    If you are editing the visual from the Visual Gallery, the sidebar appears to the right of the visual.

  3. Select on the sidebar menu. The Pivot Table Settings sidebar for the visual appears.

  4. On the sidebar, select in Rows or Columns and select a time field for the row or column. Select OK.

    The time field is selected and expands so you can select its granularity and even time intervals setting.

  5. Select the granularity for the time field.

  6. Slide Include Blanks on to request even time intervals. By default, the ability to show all values is disabled and only attributes with a value greater than NULL are displayed.

  7. Select to apply the changes to the pivot table.