Hi,
I am trying to extract data with a filter for a list of values.
For example, I have a table that contains data about fruit and their nutrition value but I want to get the data for both Bananas and Apples.
Regular QL would we:
select *
from fruits_data
where fruit_type in ('Banana', 'Apple')
When I try this in Metabase, I only get the first value.
Can I do this?
Thanks,
Chen