Datasets

Datasets

Multiple Filters

What is the best way to have multiple filters in the "does not contain" field. Some research lead to me that commas won't work. That the best way is to use a beast mode. Any updates on that end to filter?

Example:

Does not contain: S, or T

Best Answer

  • Answer ✓

    The best way is in a beast mode:

    CASE WHEN UPPER(`yourField`) IN('S','T') THEN 'Out' ELSE 'In' END

    Then use this field as a filter on the card/page.

    If I solved your problem, please select "yes" above

Answers

  • Answer ✓

    The best way is in a beast mode:

    CASE WHEN UPPER(`yourField`) IN('S','T') THEN 'Out' ELSE 'In' END

    Then use this field as a filter on the card/page.

    If I solved your problem, please select "yes" above

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In