Set custom filtering behaviour: AND or OR

Currently dashboard filters work only in “OR” fashion but this is very limiting, since upon many occasion AND behaviour is needed.
For example I have a dashboard of people and it can be filtered by the languages spoken, thanks to 1-to-N relation with a table of spoken languages by each.
It happens that I need to extract someone who speak more than one language, English AND Spanish for instance, but it’s just impossible.

hi @unguess_data Thank you for sharing your case!
Our team is actively working on the AND/OR filter and we believe it will be released soon in the next few months. We’ll let you know when it’s done :blush:

2 Likes

Hi @unguess_data,

We are excited to announce that a new feature called Condition Group has just been released to help you solve this “OR” condition use case.
It will help you create multiple “OR” conditions and nest “AND”, “OR” conditions into groups.

Check out our Release Note here and give it a try. And don’t hesitate to let us know if you have any feedback or question :blush:

Cheers,
Phuong.