Filter Excluding Blank Booleans

  • 26 July 2023
  • 3 replies

Is there a way to filter both “blank” and “non-blank” FALSE boolean cells in one filter?

I am trying to filter on check boxes that have not been checked, but however I filter (= FALSE, <> TRUE, etc), it still excludes “blank” boolean boxes, aka boolean boxes that have not been checked yet. Is there a way for a single filter to include both “blank” and “non-blank” FALSE check boxes?


Best answer by Issam Moalla 27 July 2023, 09:55

View original

3 replies

Userlevel 5
Badge +9

Hi @Jeremy Stern ,

If you are looking to keep the cells that are FALSE and Blank in your filter, the EXLUDE modifier could be the solution to your problem.
Let’s say we have the following Metrics:

  • Metric A as a filter Metric where:
    Jan 23 - May 23 : True
    Dec 22 and Aug 23 : Blank
    Jun 23 and Jul 23 : False
    Filter Metric


  • Metric B containing the values we want to filter on
    Source Metric


  • Metric C with a formula 
    'Metric B'[EXCLUDE: 'Metric A']
    Target Metric

    Let me know if this helps.



Userlevel 5
Badge +8

Hey Jeremy! Did you get forward with this one? :)