A way to count records open (but not yet closed) per dynamic period
Hello community, I have data that exists as such: RECORD ID, OPEN DATE, CLOSE DATE 12345, 01/01/2020, 02/15/2020 12346, 01/15/2020, null 12347, 02/01/2020, 3/31/2020 And I have the same data pivoted as well: RECORD HISTORY ID, RECORD ID, STATUS, STATUS CHANGE DATE 98765, 12345, Opened, 01/01/2020 98766, 12345,…
