How to count no of incidents opened before 10th of each month for this current year.

sriramsanth
Tera Contributor

I’m working on generating a report in Performance Analytics to count the number of incidents created before the 10th of each month for the current year. I need to schedule this report to run on the 1st day of each month, capturing data from the previous month.

 

I’ve tried using the "Created on Last month" filter to get the overall count, but it doesn’t allow for filtering incidents specifically created before the 10th of each month. It seems that none of the available "Relative" filter conditions provide the granularity needed for this requirement.

 

Could someone please advise on the appropriate filter conditions or a workaround to accurately capture the count of incidents created before the 10th of each month? Your guidance on how to set up this filter or any alternative approaches would be greatly appreciated.

3 REPLIES 3

Deepak Shaerma
Kilo Sage

Hi @sriramsanth 

Method 1: Using the List View and Filters
1. Navigate to the Incident Table:
- Go to the Incident list by typing incident.list in the filter navigator and pressing Enter.

2. Create a Filter:
- Click on the Filter button to open the filter criteria.
- Add conditions to filter incidents that were opened this year and before the 10th of each month.

3. Set Conditions:
Opened:
- Condition: Opened On is on or after 1/1/this year (replace “this year” with the current year).
- Condition: Opened On is before dayofyear@10 for each month.

Hi @Deepak Shaerma I want to display in trend report for the current year by month. Could you please tell me how to add second conditions which you mentioned (Condition: Opened On is before dayofyear@10 for each month.).  I don't see dayof year in filter conditions.

Hi Deepak, I want to display in trend report for the current year by month. Could you please tell me how to add second conditions which you mentioned (Condition: Opened On is before dayofyear@10 for each month.).  I don't see day of year in filter conditions.