1 Reply Latest reply: Jul 6, 2016 5:41 PM by Sunny Talwar RSS

    Tracking How Many Are Active With Activate Date & Deactivate Date

    Cael Hansen

      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)

      Issue.png

      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?