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.7K members online now
4.7K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Filter showing NULL for one variable which is a string by the way (other 4 variables are numbers)

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

So I created a filter wrt. 6 classes in a school (1,2,3,4,5,F-Klass). 

It is labeled as TEXT when creating as a datasource.

all is fine except F-Klass is showing as NULL inside filter.

 

You can checkout the created dash here. How to fix it so that it doesn't show as NULL

 

https://datastudio.google.com/open/0B-ovAVPZffFSd3ZjLWo1dmNGVmM

Filter showing NULL for one variable which is a string by the way (other 4 variables are numbers)

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

never mind. used TO_TEXT() for the class column to bring it into common format