1. Visualizing Data in Oracle Analytics Server
  2. Visualize Data
  3. Filter Data
  4. Include Null Filter Values

Include Null Filter Values

You can configure a filter to include rather than exclude null values.

You can include null values for filters created on certain column types using certain filter types. For example, you can include null values for an attribute column filter, but the filter type must be List, List Box, or Checkbox / Radio Button. You can't include null values for filters on measure columns.
  1. On the Home page, hover over a workbook, click Actions, then select Open.
  2. For a workbook or canvas filter, on the filter bar, click the filter to open the Filter dialog, and then select Nulls.
  3. For a dashboard filter:
    1. If the filter type is List, in the dashboard filters visualization, click the filter to open the Filter dialog, and then select Nulls.
    2. If the filter type is List Box or Checkbox / Radio Button, click Properties to open the Properties pane, and then click Filter Controls.
    3. Locate and expand the filter you want to include null values for, then click the Null Selection field, and select On.
  4. For a visualization filter, in the visualization, click the filter to open the Filter dialog, and the select Nulls.
  5. Click Save.