Interactive filter

Hi,

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.message)>1
    OR
  • find(lower(selectcategory),thisRow.[vision labels])>1
    OR
  • find(lower(selectcategory),thisRow.[vision objects])>1

It works pretty well when there’s only 1 keyword like “nachos”, “quesadilla”, “tortas”,… (who’s hungry? :sweat_smile: ). But it does not work for “meat burritos”. In practice, I would like to filter on “meat” OR “burritos”.

Thanks for you help guys!

@Jeremy_Corman

See if this gives you any ideas for moving forward:

2 Likes

Wonderful, thank you!

Creating a new list with separated keywords then a multi-selection filter looks like the way to go.

1 Like