Looker Studio: How to add more than 10 AND/OR filters to a chart

[sam8]

​Have you ever needed to add more than 10 OR clauses while creating a filter on a chart?

Our latest Solutions article,  How to add more than 10 AND/OR filters to a chart, walks through some workarounds for this limitation!

There are two main ways to approach this:

• Update the filter conditions to another type. When you use "Equal to", you can only enter one value per clause. But if you use "IN" or "REGEXP_MATCH", you can include as many as you want!
• Move the filter conditions into a new field. When creating a calculated field,  you can add as manyOR conditions as you like. Once you've added all of your conditions to a new field, you can filter on this new field being True!