AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
4.6K members online now
4.6K 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