Solved

Filter Excluding Blank Booleans

9 months ago
26 July 2023
3 replies
414 views

Jeremy Stern
Newly Minted Pigmenteer
1 reply

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?

icon

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

View original

3 replies

Userlevel 5

+9

Issam Moalla
Employee
47 replies
9 months ago
27 July 2023
Answer

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.

Best,
Issam