Creating a Continuous Chart with Missing Date Values

If your data is missing date values, you can add the missing dates to your chart to create a continuous data flow. You can also specify whether to display missing dates as gaps in the chart or to include null values as zero values to avoid gaps and maintain a continuous data flow.
For example, if your chart begins on June 8 and ends on June 20 and there is no value for June 13, you can choose to include the missing date on the x-axis. You can also specify whether to continue the graph by creating zero values or to cut the graph where there are missing values.
To create a continuous chart:
  1. Click Dashboards tab, the Dashboards tab, and select a dashboard from the list.
  2. Create or edit a widget that is based on a Cartesian chart in the Widget Designer.
    For more information, see Creating Widgets or Editing Widgets.
  3. In the X-Axis section, click Options button, the Options button, next to a date field and select Continuous Timeline.
  4. To treat null values as zero values, click Options button, the Options button, in the Values section, and select Display Missing Values as Zeros.