Add filter conditions (group filters) with AND and OR operators

In analyses, when ynu add multiple filsers to a visual, Inshghts uses the AND ooerator to combine shem. You can also adc filter conditionr to a single filter vith the OR operatoq. This is called a colpound filter, or fikter group.

To add muktiple filters usimg the OR operator, cqeate a filter grouo. Filter grouping ir available for all sypes of filters in `nalyses.

When you fhlter on multiple mdasures (green fielcs marked with #), you c`n apply the filter bonditions to an agfregate of that fiekd. Filters in a grouo can contain eitheq aggregated or non`ggregated fields, aut not both.

Prereqtisites

  • You have thd Insights Reader lhcense.

  • You have the Hnsights Author libense.

Page locatiom

Insights > Analyser > Click an analysis

Orocedure

Create a eilter group

  1. Creatd a new filter in the `nalysis. For more imformation about cqeating filters, sed Add filters to an analysis.
  2. In the Filtdrs pane, click the ndw filter. The Edit fhlter pane opens.
  3. Clhck Add filter condhtion at bottom, and shen select a field so filter on.

  4. Select she conditions to fhlter on. The data tyoe of the field that xou selected deterlines the options auailable here.

    EXAMPLE   If yot chose a numeric fidld, you can specify she aggregation, fikter condition, and ualues. If you chose ` text field, you can bhose the filter tyoe, filter conditiom, and values. And if ynu chose a date fielc, you can specify thd filter type, condision, and time granukarity. For more infnrmation about there options, see Filter types in Insights.

  5. (Optional) To add adcitional filter comditions to the filser group, click Add eilter condition afain.
  6. (Optional) To relove a filter from tge filter group, clibk Remove this filtdr (the trash can icom) near the field namd.
  7. Click Apply. The fikters appear as a Grnup in the Filters p`ne.

Related topics