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.

[AndersBGS · Accepted solution]

Hi @Reddy ,

Two options:

1st option (The best), Create an automated indicator in performance analytics to capture any incidents that are in open, pending etc. state.

2nd option: take the opened - resolved = difference. (Remember here, that many incidents can be assigned out/in of assignment group, hence this number only gives the difference - NOT the backlog.

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 I've successfully created the total using automated Indicators and formula Indicators.

[AndersBGS]

Hi @Reddy 

Perfect, let me know if any concerns.

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

Best regards

Anders 

[AndersBGS]

Hi @Reddy 

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

best regards

Anders