Data Studio
5.9K members online now
5.9K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

CASE Only works on text fields

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi! 

 

I'm trying  to create a new calculated field using CASE to segment sessions with continuous file sizes to size buckets (e.g. for each session, was the download for 100-500KB or 1-10MB, and so on). 

 

When trying to create a new calculated field with case on any text field, than the function works, but when trying to do so on any numeric field i get an "Invalid Formula" error. 

 

This is a CASE I've tried applying (tried it with other numeric fields, non worked): 

CASE WHEN Downloads (GB)<1 THEN '<1G' ELSE 'OTHER' END

 

Thanks in advance for any help! 

Yarden