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
- In January 3 would be active (rows 1,2,3)
- In Feb 2 would be (1, 2)
- In Oct, 3 would be (1, 2, 3)
Would love some assistance.