Filter contains multiple words (eg: stringA OR stringB)

Get Help
1

Good morning dear metabase community!!!!

We are trying to filter multiple value in a specific column with the following custom expression:

metabase_contains_multiple_error
metabase_contains_multiple_error1820×937 58.2 KB

but unfortunately the results shows nothing coherent:

image
image1324×285 33.4 KB

Do you have any idea to create a filter that contains either word1 or word2
EG: In the column product, I want all element containing coca or fanta

Thank you very much in advance for your help :star2:

2

Hi @s0025j
I don't think I understand. What you are doing is exactly how it should be done. And the results reflect that.

3

When we only say contain: coca

54
542546×1236 233 KB

We got more than 380 results only for contains coca it should be around 500 by cumulating both and we got 4lines...

4

@s0025j Post "Diagnostic Info" from Admin > Troubleshooting.