You can create a Boolean interactive filter that lets users filter report widgets
based on whether a specific field is empty or populated.
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.
You must have Performance Analytics Premium to create interactive filters.
required: hp_publisher_admin, report_admin, or admin
After you create the filter, add it to a homepage or dashboard.
In the Filter based on list, select
Set the following fields.
||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
||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.
Note: For choice list interactive filters, you can
exclude specific elements from appearing on the
filter using the Exclusion
list. However, data for excluded
choices is included when you select
All on the interactive
In the Table choice list, select the table that contains
the field to filter on.
In the Field choice list, select the field to filter