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!