Showing Unbooked Data in a Chart

Show both booked and unbooked data in a chart.

Context

You can choose to include unbooked data in your chart. Booked data shows a label for the data point, but unbooked data does not have a data label. For line charts, displaying the unbooked data breaks the line at the unbooked values.

The following chart types can show unbooked data:
  • Bar/Column
  • Stacked Bar/Column
  • Combination Column & Line
  • Combination Stacked Column & Line
  • Area
  • Line
  • Numeric Point

The Numeric Point chart shows a dash for the unbooked data. The other charts depict the unbooked data in the title area as a quantity of Null values.

Procedure

  1. Create a chart and add measures and dimensions to it.
  2. In the Builder, select a dimension and then select Start of the navigation path (More) Next navigation step Unbooked DataEnd of the navigation path.

    The chart is updated to include unbooked data for that dimension, and any dimensions listed below that dimension in the Builder. A message appears stating that unbooked data has been switched on for dimensions below the selected dimension.

  3. To clear unbooked data from your chart, in the Builder select a dimension that has unbooked data switched on and then select Start of the navigation path (More) Next navigation step Unbooked DataEnd of the navigation path.

    The chart is updated to remove unbooked data from that dimension and any dimensions listed above that dimension in the Builder. A message appears stating that unbooked data has been switched off for dimensions above the selected dimension.

Results

When unbooked data is switched on, the unbooked values are listed in the chart title area as a number of Nulls. You can hide this information by selecting Start of the navigation path More Actions Next navigation step  Show/Hide Next navigation step Null TokenEnd of the navigation path.