Dashboard that displays the total ServiceNow tickets that each agent handles per day
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-04-2024 03:51 AM
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
- Labels:
-
ServiceNow Impact
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-04-2024 04:45 AM
Thank you Mark. How do I find the maximum per agent per day in a month or even a year?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-04-2024 05:05 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-04-2024 05:08 AM
Thanks Mark, how do i get the daily maximum over a month?