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
4K members online now
4K members online now
Ask questions about Data Studio
Guide Me

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



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.