Monthly incident report in service now

[deepdeepakg]

Dear Experts,

I am new user to this community; I have a requirement where I have to create a report where I need to show Closed/ Resolved incidents monthly (say for past 6/ 12 months).

Please help me to with setup steps.

/ Deepak

[deepdeepakg]

Hi @AndersBGS 

Thanks for your response! Here I am putting condition in below format 

Not getting required output.

/ Deepak

[AndersBGS]

Hi @deepdeepakg ,

You need to remove the condition "active is true" as incidents OOTB that has been resolved 6 months ago will have went to a close state and by that is inactive. 

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

Best regards

Anders 

[deepdeepakg]

Hi @AndersBGS 

When I remove the condition active as true this is how I get and don't get result in month-by-month format, do you see something is wrong here? or need to be added?

/ Deepak

[AndersBGS]

Hi @deepdeepakg ,

You need to select a date range visualization in stead of the bar chart:

Afterwards, you need to select the "trend by" and the "per" to get the right visualization.

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

Best regards

Anders 

[deepdeepakg]

Hi @AndersBGS 

This is how it appears as below, don't know why it shows data from 2022, while I selected only last year in the filter.

additionally, do you think it is possible to make it like this where I can see all the incidents closed last year in 2023 (month-by-month) and compare it with 2024 (month-on-month YTD).

it would be a great help.

/ Deepak