"OR" filter with two distinct fields?

I would like to simply do a set of filters that is equivalent to an “OR” in SQL. In a student database with fields “program1” and “program2”, each of which can be a yes or no value, I would like to return all students who are in program1 OR program2. I am not currently seeing a way to do this in Metabase, all I can do is get all students who are in program1 AND program2. Am I missing something?

Any help with this would be appreciated!

Hi @Blake
Currently OR filters are not supported (besides messing around with SQL directly).
There’s work being done to get this implemented, but because of the massive interface change in the upcoming 0.33, it was put on hold.
You can follow the progress here: https://github.com/metabase/metabase/issues/3217

1 Like