Question

Count "Active" Contracts Between Date Windows

  • 13 November 2021
  • 0 replies
  • 10 views

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.


0 replies

Be the first to reply!

Reply