Case When Aggregation compared to another Aggregation

You can do this by adding an additional column in the ETL that you can use to Exclude the open accounts and still keep your main dataset intact to do other analysis. You would build an ETL like this: (I'll break down the steps after the screenshot)

SampleStatus - this is your initial dataset

Days to Close - This is a simple data calculator tile that finds the difference between the open and closed date fields

Rows with no close dates - Filters your dataset to only have rows where closed date is null

Select Columns - Removes all other columns except for the account number column

Removes Duplicates - makes it so we only have an account number listed once in this dataset

Add Exclude Column - Uses the Add Constant tile to create a column called Exclude with a value of Y

Join Data - Performs a Left Join with the Days to Close tile which has all of your rows and the Add Exclude Column tile and joins it on Account Number. The result is a Y in the Exclude column in all rows where there is a match of Account Numbers. 

Drop Extra Account # Column - Select Columns tile that removes the duplicate account number column as a result of the join

SampleStatusDF - Output Dataset

With this new dataset, you can drag the Exclude column into your quick filter and choose Not in Y to get rid of all account numbers that have an open note despite having a closed one earlier. 

You also have the DaysToClose column that you can use as a filter to only show those with a value of 4 or less.