Filter to show blank cells?

louiswatson
louiswatson Member
edited March 2023 in Datasets

Hey! I am looking to filter data to show columns that have empty cells. For example showing all results where 'Planning Condition Status' is blank.

I had a look at doing a Beast mode formula but wasn't sure how to put 'Blank' in the formula? Is there an easier way for me to do this?


Thankyou in advance.

Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You can do something like this to handle NULL / empty values:

    CASE WHEN `Planning Condition Status` IS NULL THEN 'Blank' ELSE 'Not Blank' END
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You can do something like this to handle NULL / empty values:

    CASE WHEN `Planning Condition Status` IS NULL THEN 'Blank' ELSE 'Not Blank' END
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • louiswatson
    louiswatson Member

    Thankyou Grant, really helpful!

  • Ashleigh
    Ashleigh Coach

    @louiswatson you can also do something like this

    IFNULL(`Region`, 'Not Mapped')

    **If this answer solved your problem be sure to like it and accept it as a solution!

Categories