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

# Count of active incident in a given quarter

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

• ###### 1. Re: Count of active incident in a given quarter

Here's an attempt.

I created a field called "Quarter_Interest" that creates the date of the quarter you are interested in. This is made from two parameters you have to choose from (Quarter and Year).

Then the calculated field "In_Quarter" has some logic and date parsing to determine if the incident was in that quarter ("Y" or "N").

See the attached workbook. Please check the logic and various situations to make sure it works correctly. (I populated a bunch of randomly generated dates in there to make this.)

• ###### 2. Re: Count of active incident in a given quarter

Thanks Chris,

That works.