Compare the number of closed vs created incidents per month

peterraeves
Mega Guru

Is it possible to see in a single report whether we have been closing more tickets than opening on a monthly basis over the last 12 months? We would like to compare the number of tickets that are opened in a single month vs the number of tickets that are closed in that same month for the last 12 months. We would like to have this report to see whether we would need to hire more people to deal with the tickets.

14 REPLIES 14

india
Tera Guru

Hi,


you can do like this



find_real_file.png



regards'


kirtesh



Pls mark as Correct/helpful/Like if you feel so;-)


I forgot to mention that I want to compare for every month over the last 12 months, without having to create 12 reports.


JennyHu
Tera Guru
Tera Guru

Hi Peter,



You can create a pie chart and group by the "Active" field.   For the filter condition, select whether the incident is created on this month or closed on this month.   This pie chart gives you all tickets that are either closed or opened this month.   Note that the Active=false tickets may include tickets that are created this month but are also closed this month.




Screen Shot 2016-11-23 at 8.42.01 AM.png


Thanks,


Jenny



Please mark this reply as Correct or Helpful if this answers your question.


I forgot to mention that I want to compare for every month over the last 12 months, without having to create 12 reports.



Btw: Your report would not be correct, because the incidents that are both created and closed this month would only be added to the 'not active' part and they should be contained in both parts.