Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Custom Filter only filtering for the first condition

CDIns
8 - Asteroid

I have a dataset that has a field called Product with 5 different products in the dataset. I only need to report on 3 of the products. So I added  a filter tool to my data set and created a custom filter:

 

[Product] = "Apples"

OR

[Product]= "Bananas"

OR

[Product]="Cherries"

 

in this months data set I can see there is Apples and Bananas, however, my filter is only picking up the Apples. Is my filter being configured incorrectly? is "OR" the wrong operator to use? 

 

Thanks, Community. 

1 REPLY 1
griffinwelsh
12 - Quasar

@CDIns Or is the correct operator to use. Check for leading or trailing whitespace in product. Also note you can use this shorter formula instead [Product] IN ("Apples","Bananas","Cherries"). If you are still having trouble, please provide your data so we can take a look at it.

Labels
Top Solution Authors