How to create a incident report per year which are opened incidents

[meragz]

Hi ,

I have a requirement to create a report which are not closed/resolved incidents by year .

Ex : Incidents are in new , IN progress or On hold which are created in 2020,2021,2022,2023,2024(current year) count.

suppose in 2020 year incidents which are not closed/resolved are 68 , the report will show 68 and in 2021 year incidents which are not closed/resolved are 150 etc ..in BAR chart.

thanks in Advance

[Sumanth16]

Hi @meragz , 

Please refer to below thread:

https://www.servicenow.com/community/itsm-forum/i-want-to-create-a-single-custom-report-per-month-we...

If you find this information/knowledge/solution helpful, Please don't forget to mark my solution and reply as helpful and accepted.

Thanks & Regards,

Sumanth meda

[Satishkumar B]

Hi @meragz 
https://servicenow.com/community/itsm-forum/i-want-to-create-a-single-custom-report-per-month-week-y...

To create a report in ServiceNow that shows the count of incidents that are not closed or resolved, categorized by their creation year, you can use ServiceNow's reporting feature to generate a bar chart. Here’s how you can set it up:

Step-by-Step Guide to Create the Report:

1. Navigate to Reports:
   - Go to Reports > View / Run in the ServiceNow application navigator.
2. Create a New Report:
   - Click on the New button to create a new report.
3. Configure the Report:
   - Name: Give your report a descriptive name, such as "Open Incidents by Year."
   - Source Type: Select "Table."
   - Table: Choose "Incident" from the dropdown.
4. Add Conditions:
   - State Condition: Add a condition to exclude closed or resolved incidents. This can be done by setting the state to exclude 'Closed' and 'Resolved':
   - `State` `is not` `Resolved`
   - `AND`
   - `State` `is not` `Closed`
   - Creation Date: Add a condition for the creation year. This can be done using the `Created` field and a script to filter by year dynamically.
5. Group by Year:
   - Group by Field: Use the `Year of Created` to group incidents by the year they were created.
   - To do this, choose `Created` in the "Group by" section and select the option to group by `Year`.

6.Choose Visualization Type:
- Type: Select "Bar Chart" as the visualization type.
- This allows you to view the count of open incidents for each year in a bar chart format.

1. Run the Report:
   - Click on Run to generate the report. Adjust any settings if needed to ensure the data is displayed correctly.
2. Additional Customization (Optional):
   - Stacked Bars: If you want to further distinguish between different open states (e.g., New, In Progress, On Hold), you can set up stacked bars by adding another group by condition based on `State`.
   - Chart Settings: Customize chart colors, labels, and legends as needed to enhance clarity and presentation.

Example Configuration:

Here’s a brief example of what the configuration might look like:

- Filter Conditions:
- `(State is not Resolved) AND (State is not Closed)`

- Group By:
- `Year(Created)`

- Visualization:
- `Bar Chart`

This setup will create a report showing a bar chart with the count of incidents that are not closed or resolved, grouped by the year they were created. You can further refine and customize the report according to your organization's needs or reporting standards. If you have specific fields or custom states, adjust the filters and grouping accordingly.

……………………………………………………………………………………………………

Please Mark it helpful👍 and Accept Solution✔️!! If this helps you to understand. 

[AndersBGS]

Hi @meragz 

This is not possible do to two reasons:

1. The reports created through the report designer will always take the current state when you open the report. Hence if if incidents in progress or on hold for 2020 was 68, then I guess they have been closed since. 
2. Performance analytics can only capture going forward, hence if you do a historical data collection, it will also take the current state of the incidents, which I again guess are closed. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[meragz]

Hi @AndersBGS ,

Thanks for the answer . But I need a year wise report . Forget about closed once . I need a report which shows year from the first incident got created. 

Suppose first incident created on 2016 . I need count of 2016 incidents and 2017 , 2018 ,2019 ,2020,2021,2022,2023 till current year .