Missing Values
Last updated
Last updated
All data types accept a special value indicating that the data is "missing". For example, in a survey if a question wasn't answered the answer field should be marked as "missing". Missing data is typically ignored by charts.
You can manage the handling of missing values in two ways:
Show them: Some charts allow missing values to be optionally included in the display. These views are: , , , and ; see these descriptions for examples. Enabling inclusion of missing values using the "Show Missing Values" property in the .
Label them: For views that can display missing values, the string used may be specified. The default string is "<NULL>". This may be specified in the Tables view in the .