Trying to classify numbers with custom field using CASE
Hi! I have a metric field of a lot of different numbers. I'm trying to create a dimension field where each metric is sorted into a category based on the number.
I'm trying to use the CASE function to create a custom field which does this. The formula I'm using is:
WHEN 0 < Number <= 5 THEN “Tiny”
WHEN 5 < Number <= 10 THEN “Small”
WHEN 10 < Number <= 15 THEN “Medium”
using this https://support.google.com/datastudio/answer/7020724?authuser=4 as a reference.
However, it isn't parsing the formula, and when I paste it into the custom field formula section, only the first 'WHEN' and 'THEN' are recognized as functions.
Any help would be great!