Skip Navigation
Expand
Behavior of multiple filters in a report
Answer ID 8868   |   Last Review Date 12/18/2018

Can I have multiple duplicate filters in a report?

Environment:

Analytics / Reports
Oracle B2C Service, All versions

Issue:

I have a report with multiple filters on the same column, each with different values. We are unsure how is it processing those filters.

Resolution:

While it is possible, we recommend that you do not, as it may cause unexpected behavior.

In general, a report will utilize the most restrictive values from all filters. However, if any of the filters has the "Make this filter selectable at run time" option disabled, the report will utilize that filter, even if it is less restrictive than the run-time-selectable filter.