Creating a dropdown filter for age range dimension

[justin-fs]

Hello. I'm sure there are a number of ways to resolve this issue but I'm hoping to find the best way from this awesome community. I have a dimension that comes from Appsheets as a EnumList formatted as age groups (0-5, 5-12, 13-15, etc) that allows for multiple selections. I would like to create a dropdown in Looker that filters results based on a single option rather than the various combos. I thought Groupings might be the way to go but that only counts the first matching entry. Any suggestions on the best way to do this? Breaking into their own metrics is an option if I can build a custom dropdown filter that combines the metrics but not sure if that is an options. 
Here's a SS of the metric column. 

Here's a SS of the current dropdown that shows all combos rather than a single option. 

[dylantrose · Accepted solution]

Hi Justin,

Looks like you have a bunch of comma delimited values. I would suggest checking out this community vis: https://lookerstudio.google.com/u/0/reporting/2b0a22a2-3992-49e1-be12-bdc22937daea/page/QPvLB

It is a drop down that expands out all values in the csv. Could be useful for your use case.

Hope this helps!