How to count no of incidents opened before 10th of each month for this current year.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-23-2024 09:14 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-23-2024 11:27 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-24-2024 08:08 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-24-2024 08:10 AM
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.