Apply an On-Page Filter

All users can apply On-Page Filters to reports, graphs/charts and dashboard when fields have been added to the filter drawer.

If you are the report creator and do see any fields, see Add a Field to an On-Page Filter.

If you are NOT the report creator and do not see any fields, you must ask the report creator to add fields for you.

  1. When fields have been added to the filter drawer for reports, graphs/charts or dashboards, the filter icon displays in blue when the filter drawer is closed.
  2. Click to open the filter drawer.
  3. Do one of the following to display the filter values:
    • Click the drop-down arrow next to the filter you want to apply.
    • Click Expand All to expand the details for all filters.
  4. Complete as follows (options vary by the type of data you select):
    • Dimensions:
      1. In the To select, start typing here field type the name of the field. A drop-down menu displays all fields in the report.
      2. Select one or more fields to add to the filter from the list.
      3. Click anywhere to close the list.
      4. Click Add Condition.
      5. Select the operator from the Equals To drop-down list. The following operators are available:
        • 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.
        • Starts With: Returns records if the field starts with the target value.
        • Ends With: Returns records if the field ends with the target value.
        • Not Contain: Returns records where the field does not contain the target value.
        • Not Start With: Returns records where the field does not begin 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:
      1. Select the operator from the Equals To drop-down list. The following operators are available:
        • 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.
        • 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.
        • 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.
        • 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.
      2. In the Value field, type the value to filter on.
    • Dates:
      1. Do one of the following:
        • Select the date range in the Start Date and End Date fields.
        • Click Add Condition and select the operator from the Equals To drop-down list. The following operators are available:
          • Current Day: Returns records for the current day.
          • Next Day: Returns records for the next day in the specified day, month, or year.
          • Previous Day: Returns records for the previous day in the specified day, month, or year.
  5. Click Apply. Note that the contents of the filters are not saved.

Note: Click Clear All to delete the contents of the filter.