Exclude null values from a visualization tile

You can remove null values by adding filters to a visualization's dimensions or measures.

When you remove null values from a field for a visualization tile, the null values are still included in any other visualization tiles that do not have the same filter applied. You can also filter a field at the global, dashboard level to remove the null values from all visualization tiles on the dashboard that use the field.

  1. Open the Analytics app and on the analytics toolbar, click Dashboards.
  2. Open the dashboard you want to exclude null values from.
  3. Select Dashboard actions > Edit Dashboard.
  4. On the visualization you want to filter null values from, select Tile Actions > Edit.
  5. On the left side of the Edit Tile dialog box, search for or navigate to the field you want to filter.
    You can choose from both the Dimensions and Measures lists.
  6. Hover over the field to filter and select Filter by field.

    A new filter is added to the Filters panel.

  7. Select "is not null" from the first drop-down list in the new filter.
  8. Click Run to see the results with the filter applied.