Create an interactive filter for whether a field is empty or populated

You can create a Boolean interactive filter that lets users filter report widgets based on whether a specific field is empty or populated.

Before you begin

You must have Performance Analytics Premium to create interactive filters.

Role required: hp_publisher_admin, report_admin, or admin

About this task

Create this filter for a field where Yes filters for records where the specified field is populated and No filters for records where the field is empty. Name the filter to represent this logical relationship. For example, you can use the name "Incident generated problem" for a filter based on the Incident table and the Problem field.

Procedure

  1. Navigate to Reports > Interactive filters.
  2. Click New.
  3. In the Filter based on list, select Boolean.
  4. Set the following fields.
    Name Description
    Name Enter a name for the filter. This name appears on the homepage widget for the filter.
    Look up name Enter a lookup name for the filter. This name appears in the Add content menu for users adding a filter to a homepage or dashboard. Use this name to help organize your filters. If you do not specify a lookup name, the Name value is used instead.
    Description Enter a description of the filter.
    UI control type Select how the available filtering options for this filter appear on the homepage widget. See Available interactive filter UI control types.
  5. In the Table choice list, select the table that contains the field to filter on.
  6. In the Field choice list, select the field to filter on.
  7. Click Submit.

What to do next

After you create the filter, add it to a homepage or dashboard.