By default, null values do not appear in charts. If, for example, a user creates a chart showing sales for each day of the week, days for which there were no sales would be omitted from the X axis.
Users looking to include null values in their charts can work around this limitation by using Cell-Based Layout (Layout 1). Cell-Based charts allow the user to define each point in a chart in contrast to layouts 2 and 3 that infer the data structure from the report's design.
To ensure that a chart displays null values, set up your report so that each point in the chart has a unique cell corresponding to that point's X and Y values. Below is how one might do this using the day-of-week sales report example. Each X value (day of the week) has its own cell, and each Y value (number of sales) also has its own cell.
The example below utilizes the custom function
DayOfWeek(). Ask your system administrator about the availability of this function in your system.
Once the report data has been set up, the user can add a chart to the report footer, select Data Layout One on the Data tab, and begin assigning each point its X and Y values.
This method will produce output including a point for "Monday," even though its Y value is null.