Data Studio
2.7K members online now
2.7K members online now
Ask questions about Data Studio
Guide Me

Trying to classify numbers with custom field using CASE

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

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”

ELSE “Large”



using this 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!