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

Simple Case Statement using LENGTH() not working

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Maybe Im missing something here.

 

See the formula below. Video_title is a string field. The whole purpose of this statement is to create a new variable called Video Title. See the space there ;-) Thanks BigQuery...

 

Anyway why is this giving an invalid formula?:

CASE WHEN Length(Video_title)>0 THEN Video_title else 'Undefined' end

 

Final_Dashboard_YF_›_Youtube.png

Simple Case Statement using LENGTH() not working

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Seems straight forward, but I can't make my own simple case statement using the same logic, get the same Invalid Formula error.  Either we're missing something or something isn't working properly with LENGTH is my guess.