How to calculate total in reports?

[Reddy]

Hi,

I have a requirement to create a report that shows the number of incidents opened and closed in the last 12 months for group X. For each month, I need to calculate the number of incidents that were opened and closed and add the total to the following month.

Here's an example to help clarify: From August 2023 to November 2023, we had 100 open incidents. In December, we opened 50 incidents and closed 40 incidents, leaving us with 10 incidents that still need to be added to the total. This brings the total to 110 incidents.

Please let me know how can I achieve it.

Thank you.

[SLK Gupta]

Hi @Reddy ,

You can use the exixting report which is available in the performance analytics.
Please follow below steps in your PDI:

1. Navigate to Performance Analytics>Dashboards

2. After opening Dashboards, select ALL and locate incident Overview Dashboard.

3.  After opening the Incident Dashboard, scroll down to the bottom and you can find a report which contains incidents sorted by opened and closed dates by week.

4. now click on the configuration button which is availble on the top right corner.

5. Now hover over the incident report and you can find the option to edit it.

6.  The report will open, and you can configure it as required you can select month instead of week, as per your requirement @Reddy 

you can use this report as a reference and you can create your required report based on this @Reddy 

If my response helps you in fulfilling your requirement, please mark it as accepted solution/helpfull @Reddy 

Thanks & Regards,

S. Lakshmikanth Gupta. 

[Reddy]

@SLK Gupta Thank you for your response.

How to calculate the number of incidents opened and closed each month and add the total to the following month?

[AndersBGS]

Hi @Reddy ,

To calculate the open - closed on a given month is easy through performance analytics, but to add the score to the next month doesn't make any sense and is not possible as such OOTB in ServiceNow. Not through the report designer and not through performance analytics. Please elaborate on your business requirement, hence it will be much more easy to help you.

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

Best regards

Anders 

[Reddy]

@AndersBGS  @AndersBGS Thank you for your response.

How do I calculate the total number of open incidents vs closed incidents for the past 12 months?

For example, if there were 30 open incidents and 10 closed incidents in October, I want to determine the monthly difference and display the total count of open incidents for 12 months.