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