Filtering a card

Stu5677

I am trying to filter off certain Key words for a column- But when I go to add several key words domo does not calculate properly.. is there any way to filter off multiple key words? The issue is these key words arent always at the start of the description so i dont think a beast mode would work. Let me know if I am wrong!

ArborRose

Filtering on multiple keywords can be tricky. You can set a column on the dataset to match the condition(s) you require. Or create a filter formula:

CASE

  WHEN `column_name` LIKE '%keyword1%' OR

       `column_name` LIKE '%keyword2%' OR

       `column_name` LIKE '%keyword3%' THEN 1

  ELSE 0

END

ArborRose

Filtering on multiple keywords can be tricky. You can set a column on the dataset to match the condition(s) you require. Or create a filter formula:

CASE

  WHEN `column_name` LIKE '%keyword1%' OR

       `column_name` LIKE '%keyword2%' OR

       `column_name` LIKE '%keyword3%' THEN 1

  ELSE 0

END

DavidChurchman

I think Arbor's solution is probably best.

If you want a 0 BeastMode approach:

If you have some ID row, then after filtering out the keyword you want, select-all on that ID row. Then clear your keyword filter, and it should still only be the rows without that keyword. Then you can apply a second keyword filter.