I’m stuck on a problem which i feel should be simple. I have data that looks like this
Start Date | End Date | Status |
---|---|---|
1/1/2021 | 1/1/2022 | Active |
11/1/2020 | 11/1/2021 | Expired |
1/1/2021 | 2/1/2021 | Expired |
6/1/2021 | 6/1/2022 | Active |
I’m trying to create a simple visual that would count the number of Active Contracts per month over the year. I have a column that automatically shows the correct status overall relative to the dates, But what I would like are results that would show
Would love some assistance.