I would like to make my interactive filter work better. The filter should look into 3 columns based on the keywords of the category I select.
Here are the 3 formulas I’ve used for this interactive filter:
- find(lower(selectcategory),thisRow.[vision labels])>1
- find(lower(selectcategory),thisRow.[vision objects])>1
It works pretty well when there’s only 1 keyword like “nachos”, “quesadilla”, “tortas”,… (who’s hungry? ). But it does not work for “meat burritos”. In practice, I would like to filter on “meat” OR “burritos”.
Thanks for you help guys!