Replacing Missing Values with Zeros
  • 18 May 2022
  • 1 Minute to read
  • Contributors
  • Dark
    Light
  • PDF

Replacing Missing Values with Zeros

  • Dark
    Light
  • PDF

If your data includes null values associated with a date, this can lead to gaps in widgets that are based on Cartesian charts.

8-6continuouschart1thumb0300.png

You can replace the missing values (Null) with zeros to create a continuous data flow.

8-6continuouschart2thumb0300.png

For example, if your chart begins in January and ends in December, but there is no value for October, you can choose to include the missing date on the x-axis. You can also choose whether to continue the graph (create zero values) or cut the graph where there are missing values.

To replace null values as zeros:

  1. Create or edit a widget that is based on a Cartesian chart.

  2. Add data to your widget.

  3. In the Values panel, click the menu and select Display Missing Values as Zeros.
    8-6displayzero.png

  4. Click Apply to save the changes to your widgets.


Was this article helpful?