Apply a Filter to a Field

Filters allow you to pare down your report until it only shows the data that you want. These instructions are on how to add a filter to a field.

To apply a filter to a field:

  1. Click on the field you want to filter.

  2. Click one of the following:
    • Basic to select a value(s).
      1. In the Type your keywords here, field type the data value on which you want to filter. A dropdown menu displays all data values that match the search.
      2. Select one or more values to add to the filter from the list.
      3. Click Apply.

    • Advanced to add conditions.

      1. Click Add Condition.

      2. Click the Condition dropdown arrow and select an operator. The following operators are available depending on the field type you select:

        • Dimensions:

          • Equals To: Returns records if the field matches the target value.

          • Not Equal To: Returns records where the field does not match the target value.

          • Contains: Returns records if the field includes the target value.

          • Not Contain: Returns records where the field does not contain the target value.

          • Starts With: Returns records if the field starts with the target value.

          • Not Start With: Returns records where the field does not begin with the target value.

          • Ends With: Returns records if the field ends with the target value.

          • Not End With: Returns records where the field does not end with the target value.

          • Pattern: Returns records that match the specified set of characters in the exact order.

          • Is Null: Returns all records where the field is null.

          • Is Not Null: Returns all records where the field is not null.

        • Measures:

          • Equals To: Returns records if the field matches the target value.
          • Not Equal To: Returns records where the field does not match the target value.
          • Greater Than: Returns records where the data in the column is less than the value in the filter.
          • Equal or Greater Than: Returns records where the data in the column is less than or the same as the value in the filter.
          • Less Than: Returns records where the data in the column is greater than the value in the filter.
          • Equal or Less Than: Returns records where the data in the column is greater than or the same as the value in the filter.
          • Between: Returns records where the data in the column is between the two values in the filter.
          • Not Between: Returns records where the data in the column is not between the two values in the filter.

        • Dates:

          • Date and Time: Returns records for the specified date and time range.
          • In the Previous: Returns records for the value selected:
            • 5 - 30 minutes
            • 1 - 24 hours

      3. One of the following fields displays depending on the operator you selected in step a:

        • Type your keywords here: Type the data value on which you want to filter. A dropdown menu displays all data values for the selected field in the report.

        • Value: Type the value on which you want to filter.

      4. Repeat steps b and c as necessary.

      5. Click Apply.