I’m trying to create a slice that does not equal to 3 entries. Basically I need an everything else slice. So If my column is labeled ‘food’, I want everything but ‘fruits’, ‘vegetables’, or ‘dairy’. I can’t seem to figure out the syntax. [column] <> “fruits”,“vegetables”,“dairy” doesn’t seem to work.
OR([Food]<>"Fruits",[Food]<>"Vegetables",[Food]<>"Dairy")
Is there a way to add in catch all after the entry? Something like Fruits*, Dairy*? I’m still getting Fruits included and I’m thinking it’s because of blank spaces "Fruits " does not get filtered.
Try:
NOT(IN([column], {"fruits", "vegetables", "dairy"}))
See also:
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |