Tracking How Many Are Active With Activate Date & Deactivate Date

[#1]

Hello all,

I have a set of data that tracks [Issue]s. Each [Issue] has a [Created On] date and a [Resolved On] date.

(See image for example)

I need to track, in a chart, how many issues are active each month.

An issue is active if it was created before or during the current month & resolved during that month, during a later month, or never.

Any Ideas?

[sunny_talwar]

I think you need to either use IntervalMatch or While loop to populate all the months between the created on and resolved on date to be able to do this. There might be a way to do this on the front end, but that could hurt performance