Recent searches
No recent searches
Need Report for hour by brand per month/week?
Posted Jul 03, 2021
Does anyone have the exact steps to take to compile a report that gives you all agents time spent on all tickets by brand fir the month/week. Using THE TIME AP. All the data is in there but how do I pull it out. Support can't tell me how to do. All they can do is point me to an irrelevant article!
0
9
9 comments
Jacob the Moderator
Hi Tom,
If you've already created the custom metrics as per this article, then you should be able to create something like this.
Is that what you're interested in?
0
Tom Dawson
This is exactly it. Where do I find the first metric, Sum(ticket handling time (hrs))
0
Jacob the Moderator
Great!
You will need to define the metric you want
https://support.zendesk.com/hc/en-us/articles/360022186134-Time-Tracking-app-metrics-you-need-to-be-measuring#ariaid-title7
You can find general instructions on how to create Standard calculated metrics here
https://support.zendesk.com/hc/en-us/articles/360022184554#topic_g2g_hdb_hv
I hope that helps you out.
0
Tom Dawson
So I figured that part out and this is what it looks like:
How do I do the brand a brand b thing?
0
Tom Dawson
Also how do I get the time to display in hours?
0
Jacob the Moderator
Looks like the last thing you need is to select a table visualization.
On the right-most side, you have a column chart icon at the top, click that and select the table visualization.
0
Tom Dawson
Great, how do I change the time period on demand?
Really appreciate you, Jacob.
0
Jacob the Moderator
You would want to add a date based filter, either on the report, or you can add the report to a dashboard and add filters there.
https://support.zendesk.com/hc/en-us/articles/360034902733-Best-practices-for-using-dashboard-filters
You can add bookmarks to the dashboard to save a particular time period, like last month, quarter or year for example.
0
Tom Dawson
Thanks so much Jacob,
Please close this ticket.
1