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

Filtering with empty value

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I am building a report and I want to be able to filter on the basis of a NULL value. 

 

I want to show levels of a report as there is a folder structure. I want to be able to show each level by itself. I have created a custom field that returns a NULL level I want to report on but I can't select NULL values in the filter it seems

 

example

LV1 (data) LV2 (client1) LV3 (NULL) 

LV1 (data) LV2 (client1) LV3 (Campaign1)

LV1 (data) LV2 (client1) LV3 (Campaign2)

LV1 (data) LV2 (client1) LV3 (Campaign3)

 

above I want to only show the first row.