Cloudera Docs

Including null values in a visual

In , the quick date filter enables you to provide a quick selection of date ranges for visualizing your data.

You have created dashboard with a scatter visual that plots created and resolved issues. For instructions on how to create this dashboard, see Creating a dashboard with date filters.
  1. Hover over the upper right corner of the resolved filter, and click the (Gear) icon to configure the filter.
  2. In the Settings modal window, click the Style tab and select the Permit selection of NULL values option.
  3. Click APPLY.
  4. Click the Calendar icon on the resolved filter.
    The Include NULLs option appears in the drop-down menu.
  5. Close the drop-down menu without selecting the Include NULLs option.

    The following image shows that the Current Parameters on the top right corner shows resolved.include_nulls: false, indicating that the Include NULLs option was not selected in the filter.

  6. Click the Calendar icon on the resolved filter and select the Include NULLs option.

    The following image shows that the Current Parameters modal in the top right corner shows resolved.include_nulls: true, indicating that the Include NULLs option was selected in the filter. The visual now includes the null values in the dataset.

  7. To verify that the visual includes null values, hover over one of the selections to view the tooltip.

    The following image shows that Date Closed has a 'NULL' value.