2 Replies Latest reply on Aug 25, 2016 8:10 AM by Tejal Narkar

    Count of active incident in a given quarter

    Tejal Narkar

      Hi All,

       

      I need some help to create a calculated field to count the number of active incidents in the given quarter of interest. An incident is active if  it was created, closed or still open in that particular quarter. For example, refer below data:

      Incident 1: Active since it was open in the quarter of interest(assume the quarter of interest is Q1 Jan 2016)

      Incident 2: Active since it was reported in that quarter

      Incident 3: Active since it was closed in that quarter

      Incident 4: Active since it was created and closed in that quarter

      Incident 5: Active since it is open in the quarter of interest

       

      I have attached the excel file.

       

      Thanks,

      Tejal