Hi
I am stuck at a small report (unable to find the right reasons). Need the following in a Tabular Format.
This is required on every end of the day or can have a Time filter.
| Date | Agent Name | New Unassigned Tickets | Open Tickets | Pending Tickets | On Hold Tickets | Solved Tickets | Total End Of Day |
| 01-10-2022 | 101 | 101 | |||||
| 01-10-2022 | Agent 1 | 32 | 4 | 1 | 43 | 80 | |
| 01-10-2022 | Agent 2 | 23 | 4 | 2 | 23 | 52 |
What are you trying to get or accomplish mate?
Hey Jahn,
I am looking to measure the Tickets volume and agents productivity in a single Table for a day. For us the important parameter is to gauge as how many tickets were worked upon by a particular agent in a day.
Wish to know at the End of The Day as how many Unassigned Tickets were left, how many have status as Open, Pending and On Hold and How many tickets were solved (in a single Table) with Time filter. So if i want to see the status of the tickets on an earlier date then it should show me the status of that days (or periods) agent productivity.
It essentially has to show the complete days working of an Agent.
I hope I am able to explain
You can use the below mate.
Metrics:
(Count) Tickets Created
(Count) Solved
(Count) Unsolved
(Count) New
(Count) Open
(Count) Pending
(Count) On Hold
Attributes in Row
Assignee Name
Filter:
Ticket Created Date or Ticket Solved Date (depends on your business)
Hope this helps mate.
Thanks my friend,
The issue is if I take time filter as Tickets created, then it gives me the count of only the tickets created in that period, and if I take the filter as Tickets solved, then it gives count of only solved tickets. I actually want to know the count of tickets worked upon on that period irrespective of the date created or solved.
Will the filter of Tickets updated give the right answer?
I tried using the formula given above, but I can't find Ticket Pending, Ticket Open etc. How to to get that
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
It seems like you want to create a report showing the number of ticket updated by agents during the day, it will show you the number of tickets worked by agent.
You can accomplish that by creating a report via the Ticket update history dataset and using the attribute “status update” and filtering it by updater role :
I hope this helps,
Best