Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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?