How do I bucket (group) different Levels in Beast Mode?

I have levels ranging from Level 02 - Level 16.

I'd like to group them by Level 02 - Level 07

Level 08 - Level 11

Level 12 - Level 16

Best Answer

  • TheLookout
    TheLookout Contributor
    Answer ✓

    Create a beastmode. Replace 'FIELD' with the column that contains the values you're looking at.

    CASE

    WHEN 'FIELD' IN ('Level 02','Level 03','Level 04','Level 05','Level 06','Level 07') THEN 'Level 02 - Level 07'

    WHEN 'FIELD' IN ('Level 08','Level 09','Level 10','Level 11') THEN 'Level 08 - Level 11'

    WHEN 'FIELD' IN ('Level 12','Level 13','Level 14','Level 15','Level 16') THEN 'Level 12 - Level 16'

    END

Answers

  • TheLookout
    TheLookout Contributor
    Answer ✓

    Create a beastmode. Replace 'FIELD' with the column that contains the values you're looking at.

    CASE

    WHEN 'FIELD' IN ('Level 02','Level 03','Level 04','Level 05','Level 06','Level 07') THEN 'Level 02 - Level 07'

    WHEN 'FIELD' IN ('Level 08','Level 09','Level 10','Level 11') THEN 'Level 08 - Level 11'

    WHEN 'FIELD' IN ('Level 12','Level 13','Level 14','Level 15','Level 16') THEN 'Level 12 - Level 16'

    END

  • Buck
    Buck Member

    @TheLookout You're awesome!!!! Thank you sooo much! Huge Help!