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?
Post "Diagnostic Info" from Admin > Troubleshooting.
Metabase just sends your SQL to your database, so I'm guessing that you don't have correct data, or you are returning more rows than what is being displayed.
Try with
select fruit_type, count(*)
from fruits_data
where fruit_type in ('Banana', 'Apple')
group by fruit_type
I have data for a lot of fruits in this table.
I want to put a filter like in the image below. This will allow other folks that do not know SQL to filter the results.
Again - I want to use: fruit_type in ({{fruit_type_filter}})
@flamber field filter is a good feature and i use it a lot. But it will be great if we can improve it a little bit. Fielt filter take all values and show you as multiselection. Sometimes we need to show not all values but only selected one in multiselection choice. Can we improve this feature and give us management to choose which elements show in multiselection?
If you want to use a regular Text filter, then there's several options to make that work with comma separated strings, but it depends heavily on the specific database type: https://github.com/metabase/metabase/issues/4728
@Huseyn There are 2000 issues. Click on issues to help prioritize them. Upvotes is not the only indicator of priority - there are several internal priorities as well.
The public roadmap is available here: https://www.metabase.com/roadmap/