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!
try “NULL”
this doc shows examples of many filter expressions include null and not null https://docs.looker.com/reference/filter-expressions