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

jimsteph
jimsteph Contributor
edited December 2023 in Datasets Ideas

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.

Tagged:
1
1 votes

Active · Last Updated

Comments

  • 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?

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"