Exago Logo
Search
Generic filters
Exact matches only

Displaying Null Values in Charts

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.

To ensure that a chart displays null values:

  1. Set up the 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.
    5bTs2u8eKA.png

    Note

    This below utilizes the custom function DayOfWeekName(). Ask the system administrator about the availability of this function.

  2. Add the chart to the report footer section.
  3. On the Chart Wizard’s Data tab, advance to the Data tab, and begin assigning each point its X and Y values.
    pa4WOCACKL.png
  4. Click ApplyBtn.png Data Layout…, then click Cell Based Chart and finally click Okay.
  5. Click Finish to close the Chart Wizard.

This method will produce output including a point for Monday, even though its Y value is null.

l12cikUv5k.png
The example report in the Report Viewer
Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Table of Contents