Reporting on average number of tickets in a queue per month

Ben88
Kilo Explorer

Hello,

I would like to know how can I create a report of the average number of tickets (at the end of a day )in a queue per month. 

Please let me know if you need further informations.

Thanks a lot,
Regards

1 ACCEPTED SOLUTION

Hi there,

A bit limited, though you might have a look at Metrics. Out-of-the-box, already several metrics are available. I don't know your full requirement, though maybe Metrics can already do the job for you.
For example measuring on which Assignment Group an Incident is, start time, end time, the duration, when assigned to an other Assignment Group, etc..

In the Navigator:
"Metrics > Definitions". These define what is being captured.
"Metrics > Instances". The collected data.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark

---

LinkedIn
Community article list

 

Kind regards,

 

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

 

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

LinkedIn

View solution in original post

8 REPLIES 8

Hi there,

A bit limited, though you might have a look at Metrics. Out-of-the-box, already several metrics are available. I don't know your full requirement, though maybe Metrics can already do the job for you.
For example measuring on which Assignment Group an Incident is, start time, end time, the duration, when assigned to an other Assignment Group, etc..

In the Navigator:
"Metrics > Definitions". These define what is being captured.
"Metrics > Instances". The collected data.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark

---

LinkedIn
Community article list

 

Kind regards,

 

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

 

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

LinkedIn

Ben88
Kilo Explorer

Hi, 

tickets are in the queue if they are active and not closed/resolved  :

 

 

find_real_file.png

Thanks

Hi,

Through reporting you can achieve this.

Create new report Give appropriate name to it.Under source type select the table and give table name under table field.

Select the visualization type.

Under configure select the group by as state(check attached screenshot)

find_real_file.png

Like this you will get the report of all tickets which are in queue.

Thanks,

Dhananjay.

 

Dhananjay.

Hi,

Did this solve your question? Or do we need to follow-up on this?

Please mark this answer as correct if it solves your question. This will help others who are looking for a similar solution. Also marking this answer as correct takes the post out of the unsolved list.
Thanks.

Regards,
Dhananjay.