Add Filters
You can select fields to filter your report's output.
To add a field as a filter:
- Select Add Filter on the column heading or click the Filters tab and drag the desired field into the appropriate filter type (Prompted or Static).
-
Select
Match All or
Match Any if you want to group the results.
The following options are available when you add fields as a filter:
-
Select List: This filter type allows you to select filter criteria from a drop-down list.
-
Keyword: This filter type allows you to enter keywords as the filter criteria.
-
Date Picker: This filter type allows you to enter a date or date range as the filter criteria.
-
-
Select an operator from the drop-down list. Depending on the filter type that you selected, the following options become available
Operator Options Select List - One of / Not One of: Matches a value in a list (or not)
Date Picker - Equal to / Not Equal To: Checks if the value is equal or not
- Greater than
- Greater than or Equal to
- Less than
- Less than or Equal to
Keyword - Equal to / Not Equal To: Checks if the value is equal or not
- Greater than
- Greater than or Equal to
- Less than
- Less than or Equal to
- Like: Will return results that exactly match what is entered
- Not Like: Will return results that do not match what is entered
Parent Topic: Step 2: Build a Report