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