Native Derived Table Filter

Hello all,

How would I apply a NULL filter on a Native Derived Table using an explore source? I understand how to do this via SQL, but can’t figure it out for explore source. The image below is from the Looker webpage on how to use a filter. It appears to be a text based filter, so if I typed in IS NULL, it when only show me results that had a string of “IS NULL” whereas I just want all null records. Thanks for the help!

755b89a0-e826-41a1-8c72-ae0a507c42b3.png
https://docs.looker.com/data-modeling/learning-lookml/creating-ndts
0 1 505
1 REPLY 1

try “NULL”

this doc shows examples of many filter expressions include null and not null https://docs.looker.com/reference/filter-expressions

Top Labels in this Space
Top Solution Authors