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

Buck · 2023-05-26T22:41:35+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

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

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

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