How do I create a report showing ticket closure percentages

Peter B
Giga Expert

Hello,

I would like to create a report showing data of the ticket closure rate for a month's worth of data. For instance, I would like to generate a report showing out of "x" amount of tickets that were opened this current month, we are closing "this percentage" of them. I am new creating reports so any help would be great thank you.

1 ACCEPTED SOLUTION

sachin_namjoshi
Kilo Patron
Kilo Patron

 

use below solution

 

https://community.servicenow.com/community?id=community_question&sys_id=a3bdc76ddb9cdbc01dcaf3231f96...

 

If you need percentage, then you will have to use performance analytics.

 

Regards,

Sachin

 

View solution in original post

5 REPLIES 5

sachin_namjoshi
Kilo Patron
Kilo Patron

 

use below solution

 

https://community.servicenow.com/community?id=community_question&sys_id=a3bdc76ddb9cdbc01dcaf3231f96...

 

If you need percentage, then you will have to use performance analytics.

 

Regards,

Sachin

 

Lakshmi51
Giga Guru

Go to reports > view  create reports and give the condition created by this month  and go with pie or bar chart it will help

 

find_real_file.png

 

Please mark the answer correct and also if this help mark helpful.

 

Thanks,

 

Priya Shid1
Kilo Guru

Hello peter,

you can do that using report module given .you can use stack by condition as state display data as active and aggregation as average state .

Please mark if that helps!!

 

Peter B
Giga Expert

Thank you everyone, my question was answered!