Imagine I have the following pipe delimited dataset on a dashboard with many charts on Looker Studio:
fruitbasketid|fruits
1|orange, apple, pear
2|orange
3|apple, pear
4|pear
I want to have a filter option (ideally a dropdown) that includes any data where fruits contains the text "orange", or contains "pear", or contains "pear" or "apple" at the same time, or "orange" or "pear" at the same time, etc. If I click the dropdown option "Orange" I should see rows 1 and 2, and if I click both "orange" and "pear" I should see ALL 4 rows . I want to make a filter where "orange" doesn't automatically mean "not apple". I've asked Gemini in 10 different ways and none of the solutions are actually functional.
LinkedIn
Twitter
