Report on incidents logged and closed in the previous month

[Thereza Van der]

Good afternoon all 🙂

I would like to draw a report with all incidents opened and closed in the previous month. I can do that, but what I am battling with is how to I get older incidents that were logged earlier but closed in the previous month to also display on my report? E.g. I want to see all calls opened and closed during January, but if there were calls logged in December but closed in January it must also display on my report.

Any suggestions please.

Regards

Thereza

[AndersBGS]

Hi @Thereza Van der ,

You can create a time series report for incident where you trend by month by opened. Afterwards you add an dataset where you trend on month by closed.

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

Best regards
Anders 

[Thereza Van der]

Thanks Anders

Let me try to recreate your report to see if it works. Will get back to you 🙂

[SreerajCP]

How do we add a dataset where you trend on month by closed.

[AndersBGS]

Hi @SreerajCP ,

Look at this: https://www.servicenow.com/docs/bundle/xanadu-now-intelligence/page/use/reporting/concept/c_Multiple...