Case When Aggregation compared to another Aggregation
I am looking for a way to get a count of accounts that have had a note closed within 4 days of it being opened. The issue I am having is when an account has a note that is closed within the 4 days but has had another note opened but is not closed within the 4 days within the same time period of the first note.
Account# Noteid OpenDate ClosedDate
4 1459 1/15/2019 1/16/2019
4 1460 1/16/2019
I need to get both to not count toward the count of accounts closed within 4 days. I am looking for a beast mode because the report that is needed will need to be based on a date range in the card.