In Dataset Data tab, add null as filter criteria for date fields.

jimsteph

I need to be able to filter on the presence or absence of NULL in a date or datetime column when looking at a dataset on the Data tab. If there's a way to do this that doesn't involve creating temporary subsets that filter based on a formula or beast mode, please let me know.

jaeW_at_Onyx

just add a column date_is_not_null and use a CASE statement.

CASE when date is null then 0 else 1 end

Kimball would say that all dimensional columns should never contain a NULL. Can you fill it?