Report for Incidents Created and Resolved in a month

Subh
Kilo Contributor

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:find_real_file.png

1 ACCEPTED SOLUTION

Priyanka Vasant
Tera Guru

Hi Subh,

Change the group by Field to state that will filter the records based on the state.

once the report generated you can just put the mouse pointer to the top of the bar that will show the count. 

Make changes as shown in below image.

find_real_file.png

Mark helpful or correct based on impact.

Regards,

Priyanka A.

View solution in original post

11 REPLIES 11

Hi @Subh ,

I'm glad that it worked for you.

Cheers.

Aldrin Panelo
Giga Contributor

In the Group by, choose the incident state field. then add filter to only show the incident state you need to display in your chart.

Priyanka Vasant
Tera Guru

Hi Subh,

Change the group by Field to state that will filter the records based on the state.

once the report generated you can just put the mouse pointer to the top of the bar that will show the count. 

Make changes as shown in below image.

find_real_file.png

Mark helpful or correct based on impact.

Regards,

Priyanka A.

Subh
Kilo Contributor

Thak you Priyanka it worked for me, see below

find_real_file.png

Is it possible to group by monthly basis so that I can see the details for every month 

Something like this - group by Months and stack by Priority, see below

find_real_file.png

Appreciate your answer to it.

 

Thanks.

 

Regards

Subh

Hi sub,

yes you can use stack by Priority.for that you need to select option priority in stack by field.

But if you want on Report on monthly basis then you need to use Performance Analytics.