Add Filters

You can select fields to filter your report's output.

To add a field as a filter:

  1. 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).
  2. 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.

  3. 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