Report for Incidents Created and Resolved in a month

[Subh]

I want to create a report which helps me to see the number of incidents created and resolved in a month 

I have created a bar graph and have set correct filter dates and my assignment group.

However how do I get bars for the incident status like below:

[Utpal Dutta1]

Hey Subh,

Please go through the the docs of ServiceNow: https://docs.servicenow.com/bundle/kingston-performance-analytics-and-reporting/page/use/reporting/t...

Also there is a community post already for your problem: https://community.servicenow.com/community?id=community_question&sys_id=43c78fe9db1cdbc01dcaf3231f96...

Please mark my answer Correct and Helpful.

Thanks and Regards:

Utpal Dutta

[Utpal Dutta1]

Also please refer to this community post: https://community.servicenow.com/community?id=community_question&sys_id=1129293cdb0f1b449d612926ca96...

Don't forget to mark my answer Correct and Helpful.

[Subh]

Hi Utpal 

Thank you for your reply. I have created many reports and know how to add related table fields etc.

I have gone through the posts, the result dont give me the bars of status. 

Please see screenshot below:

 

What I need is the following - tickets count based on How many created, Resolved and In progress in this month

The last option will be to export a List with all incidents and use pivot in excel to have the data, however, I was looking if it can be done in SNOW.

Thank you for your help.

Regards

Subhash

[Onkar Pandav]

Hi,

You can try by selecting the "Group by" field as "State", as state has choices like In progress, Resolved, Etc.

But if you want to show "Created" also then in you can try with "Additional group by" option.

Refer below screen shots.

Output:

It is difficult to have report with created and states of incidents.