Dashboard that displays the total ServiceNow tickets that each agent handles per day

kiyenyfelix
Tera Contributor

Create a dashboard that displays the total ServiceNow tickets that each agent handles per day, then calculate a maximum number per month, and average that maximum over the number of agents in a team. The format would be similar to what is in the ServiceNow analysis spreadsheet attached. I have tried but i am not getting the exact request

7 REPLIES 7

Thank you Mark. How do I find the maximum per agent per day in a month or even a year?

 

Mark Manders
Mega Patron

If you have a simple bar chart on 'resolved' per month by resolved by, it will already be sorted by the resolved_by with the highest number.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

Thanks Mark, how do i get the daily maximum over a month?