Creating Interactive Filters of different types

You can create and configure Interactive Filters for multiple field types.

Before you create an interactive filter, choose which type of filter to create.

주:

From the Australia release, only users with the report_admin role can create and edit Core UI interactive filters. To create filters in Platform Analytics experience, see Filters in Platform Analytics.

표 1. Interactive filter types

Type	Description
Choice list	Allows you to filter data based on the value of a specific choice list. You must select the table and choice list field. The filter affects reports on the specified table.
Reference	Allows you to filter data based on the value of one or more reference fields. You must select the referenced table, as well as reference fields from other tables. The filter affects reports on tables that have the specified reference fields. 주: Reference interactive filters do not support string fields.
Date	Allows you to filter data based on the value of one or more date fields. You must select the tables and date fields. The filter affects reports on the specified tables.
Boolean	Allows you to filter data based on the value in a specific true/false field. You must select the table and the true/false field. The filter affects reports on the specified table.
Group	Allows you to display multiple interactive filters in a single widget on a dashboard. Users viewing the dashboard can select which grouped filters to apply.
Empty/non-empty	Filter based on whether a field contains a value.
Cascading	Allow you to filter based on multiple values in a hierarchy, such as by region, country, and city.

• Create a choice list interactive filter
  A choice list interactive filter enables users to filter report widgets based on the value of a choice list.
• Create a reference field interactive filter
  A reference field interactive filter allows users to filter report widgets based on the value of a reference field.
• Create a date interactive filter
  A date interactive filter allows users to filter report widgets based on the value in a date field.
• Create a Boolean interactive filter
  A Boolean interactive filter allows users to filter report widgets based on the value of a true/false field.
• Create a group interactive filter
  A group interactive filter allows users to select multiple interactive filters to apply to reports on a dashboard.
• 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.
• Create a cascading filter
  Cascading filters allow you to filter based on multiple values in a hierarchy, such as by region, country, and city. Lower-level choices are filtered by the values selected at higher levels.
• Interactive filters on database views and table hierarchies
  When you create an interactive filter on an extended table, you can also apply the filter to database views and to the other tables in the hierarchy. The hierarchy includes all parent, child, and sibling tables.
• Available interactive filter UI control types
  The interactive filter UI control type field provides several options for displaying the filter.