Skip to main content
Sets the text a table visualization shows in place of the default null symbol (∅) for this measure’s null values.

​
Syntax

​
Properties

​
object
The name of the measure.

​
Behavior

A table chart resolves a cell’s null text in this order:
  1. The column’s Null display setting
  2. The measure‘s null_display value.
  3. The table’s Null display setting.
  4. The default ∅ symbol.
To show a blank cell for a measure with null_display set, set the column’s Null display setting, or set null_display to an empty string (""). An empty string is a valid value for null_display and displays as a blank cell. This is different from leaving null_display unset, in which case the table’s setting is used instead.
null_display only affects table chart cells and subtotal rows. The Results table, pivot headers, the formula bar, and downloads always show ∅ for null values.

​
Examples

​
Descriptive null text

orders.view

​
Explicit blank value

orders.view