Average Ticket Count by Day | Community
Skip to main content

Average Ticket Count by Day

  • November 16, 2022
  • 3 replies
  • 0 views

Simple recipe I'm sure but how do I see what our average daily ticket count is?

3 replies

Jahn11
  • November 17, 2022

In Explore there is actually a metric called "Tickets Created - Daily Average"  then you can filter which week, month, or year you want to see your daily average. 


  • Author
  • November 17, 2022

Could you maybe provide a recipe? Sorry I have a hard time starting from scratch. I don't see that under the metics. Not sure what to put in columns or rows either. @jahn11


Jahn11
  • November 17, 2022

Hello Kate,

1. Go to explore - https://yourdomain.zendesk.com/explore#/reports-library 
2. Click "New Report" upper right hand corner
3. Select Dataset "Support" then sub dataset "Support-Tickets"
4. In Metrics select "SUM(Tickets Created - Daily Average) (COUNT(Tickets)/DCOUNT_VALUES([Ticket created - Date]))
5. In Rows select "Tickets Created - Day of the week" or depends on what you prefer to select then you can filter the date which week, month, or year you want to see. 

Hope this helps!