OR-filters-in-Interactive-Mode

Variables

Once there’s at least one filter in the Filters section, an OR button will appear below the Filter box. To add a new OR filter, click the OR button and drag your column to the new OR field.

OR-filters-in-Interactive-Mode

Once you drag a column to the OR filter field, another OR button will appear beneath it. You may add as many OR boxes as you need this way.

OR-filters-in-Interactive-Mode 1

Any filters in the same field will have an AND between them.

Examples

OR-filters-in-Interactive-Mode 2

Description like '%Ad%'
AND
Description like '%Event%'

OR

Description like '%Web%

OR

Cost greater than 100

OR-filters-in-Interactive-Mode 3

Description is null

OR

Description is not one of (Sales, Print)

OR-filters-in-Interactive-Mode 4

Cost greater than 100

AND

Description like '%Event%'
OR
Description is null

Because each section has an OR between it, we’ll need to do something a little different to get this to work: we’ll add our AND filter to both OR sections.


Related Variables Help Articles

See more