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.
- Click , the Dashboards tab, and select a dashboard from the list.
- Create or edit a widget that is based on a Cartesian chart in the Widget Designer.
- In the X-Axis section, click , the Options button, next to a date field and select Continuous Timeline.
- To treat null values as zero values, click , the Options button, in the Values section, and select Display Missing Values as Zeros.