Rename filter values to "Other"

user000253
user000253 Member
in Charting

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

Other


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


Thanks

Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    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!**

Answers

  • GrantSmith
    GrantSmith Coach
    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!**

Categories