Rename filter values to "Other"

I am trying to apply a filter at Card Level. For this specific card, I only want to show the filter options as either "Name 1" or "Other".

I want the rest of the values to be bundled under "Other", so I only show two options for applying the filter:

Name 1


Is it possible to do this via beast mode so it only applies to my dashboard and card?



Best Answer

  • GrantSmith
    GrantSmith Indiana 🥷
    Answer ✓

    Hi @user000253

    You can use a beast mode to create your custom buckets (Name 1 & Other) and use that as your quick filter.

    CASE WHEN `name` = 'Name 1' THEN `name` ELSE 'Other' END

    This is assuming your column is called 'name'

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**