DataLens

Configuring the display of null values

Note

The setting is only available for charts that have at least one X or Y axis:

  • Line chart
  • Area chart (Stacked and Normalized)
  • Column chart (including a Normalized column chart)
  • Bar chart (including a Normalized bar chart)
  • Scatter chart

If the source data includes a row where the measure value is null, the chart will not be built for that point at default settings (there will be a gap in the line, or column/point will be skipped). For example, if the source has a row with a date (20.07.2022) but the sales amount for it is missing.

Example of a chart with a gap

image

Source table

OrderDateSales
15.07.2022301629
16.07.2022453595
17.07.2022977583
18.07.2022527834
19.07.2022870054
20.07.2022null
21.07.2022569650
22.07.20221116034
23.07.2022883208
24.07.20222359483
25.07.20221137851

You can configure how the chart will display null values in the chart section settings:

  1. In the section with a measure whose values you want to show, in the top-right corner, click (the icon appears when you hover over the section).

  2. Specify a value for the Null values option:

    • Ignore: Do not show points with null values. On the chart, it will appear as a line gap, skipped column or point.
    • Connect: Connect neighboring points with values other than null with a line.
    • Display as 0: Replace null values with 0.

  3. Click Apply.

Example of replacing null with 0

image

If a row is missing from the source data completely, the Null values option will not change the way the chart is presented. For example, if the source does not have a row with a certain date (20.07.2022), nothing will be shown for this date on the chart.

Example of a chart with a missing date

image

Source table

OrderDateSales
15.07.2022301629
16.07.2022453595
17.07.2022977583
18.07.2022527834
19.07.2022870054
21.07.2022569650
22.07.20221116034
23.07.2022883208
24.07.20222359483
25.07.20221137851

Note

To display a zero value for a date missing from the table:

1. Add a row with this date and a null value to the source.
2. In the chart settings for the relevant indicator, select Display as 0 for the Null values option.

Previous
Configuring the navigator
Next
Creating a color palette