Need Report for hour by brand per month/week? | Community
Skip to main content

Need Report for hour by brand per month/week?

  • July 3, 2021
  • 9 replies
  • 0 views

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!

9 replies

Jacob20
  • July 7, 2021

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?


  • Author
  • July 9, 2021

This is exactly it.  Where do I find the first metric, Sum(ticket handling time (hrs))


Jacob20
  • July 9, 2021

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.


  • Author
  • July 9, 2021

So I figured that part out and this is what it looks like:  

 

 

 

How do I do the brand a brand b thing?


  • Author
  • July 9, 2021

Also how do I get the time to display in hours?


Jacob20
  • July 9, 2021

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.


  • Author
  • July 9, 2021

Great, how do I change the time period on demand?

Really appreciate you, Jacob.


Jacob20
  • July 9, 2021

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.


  • Author
  • July 9, 2021

Thanks so much Jacob,

 

Please close this ticket.