Group in Beast Mode

user000253
user000253 Member
in Charting

Is there a calculated field in beast mode to group names for a filter? For example, data looks like this on card slicer:


Customer A- UK

Customer A-USA

Customer A- Mexico

Customer B- UK

Customer B-USA

Customer B- Mexico


Is there way of grouping Customer As and Customer Bs together to show on the card slicer only the following:

Customer A

Customer B

Tagged:

Answers

  • GrantSmith
    GrantSmith Coach

    You'd want to split your data so you have two columns, one for customer and one for country. You can use SPLIT_PART to split the strings based on a specific character and which part you want:

    Customer (get the first part when splitting the string into sections based on the - character:

    SPLIT_PART(`field`, '-', 1)

    Country:

    SPLIT_PART(`field`, '-', 2)

    Then use that customer beast mode as your card slicer. You'd want to make sure to save the beast mode to your dataset.

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

Categories