Insights recipe: Tickets by time of day created

Return to top
Have more questions? Submit a request


  • Jessica Ferreira

    This is great but it shows me the accumulation of all my tickets. IS there a way to narrow it down by day, week or month please?

  • Solène Regnier

    Hello Jessica,

    Click on the menu Filter and you will be able to filter your report by date. Please have a look to these 2 links for more details: 


  • Justin

    This seems like a great start. Is there any way to export more exact data about when tickets were created (i.e., the timestamp instead of just the hour)?

  • Dwight Bussman
    Zendesk Team Member

    Hi Justin,

    You could use the method described in the following article to get the exact time as an epoch timestamp: Once there, there are a few ways to convert that epoch timestamp to current time.

    Unfortunately, there isn't a good way to get a standard timestamp, though.

  • Alex Zlatkus

    Maybe I missed a step, but how do you get each hour to be a different color?

  • Dwight Bussman
    Zendesk Team Member

    Hi Alex,

    Sorry we didn't include that step in our article! In order to have each out get its own color, you will need to go into the configuration:

    then drag "Hour Ticket Created" from the Horizontal (x) line down into the Series section and hit apply.


    Please let me know if this helps!

  • Alex Zlatkus

    Works like a charm!

    Thanks Dwight!

  • Dwight Bussman
    Zendesk Team Member

    My pleasure! Thanks for reaching out :-)

  • Yen

    Hi there!  

    Was wondering how I could get the avg no. of tickets per hour on any given week or month.  The above example shows the accumulated no. of tickets rather than an average.

    Can anyone help?




  • Russell Dyas



    I maybe missing something but can link the report so that takes into account timeline selected on a dashboard?

  • Virgenru

    Hello- Is there any way to narrow down the intervals to 1/2 hour? Our office hours run on the 1/2 hour and we are trying to figure out tickets that arrive outside of business hours. Thanks! 

  • James Sanford

    Hey Virgenru!

    The default metrics within Insights for this type of reporting do only break down to Hours as the shortest interval.  If you're looking to achieve greater granularity than that you're going to be best served by referencing the article mentioned previously in this thread by Dwight.  Using that method you can obtain the Epoch timestamp and convert that to current time.  I believe that although this will achieve what you're asking for, the resulting timestamps will likely be less than ideal for the type of reporting you're trying to achieve, and would recommend trying to work within the scope of hours as much as possible.

  • Kelsey Greenawalt

    Our team is spread across many different timezones. Are the hours generated in this sort of report based on the time of day the client created the ticket? If so, how can we convert them to GMT/UTC so we can overlay avg number of tickets with number of agents we have working at any given time? 

  • Ray Roth
    Zendesk Customer Advocate

    Hey Kelsey!

    This report will be based on the timezone the Zendesk account is set to, not the users themselves. Here is an article on this for your reference: 

  • Candice

    Thanks for this.

    How would I have a stacked bar graph for all the days of the week? Right now I just exported every single day for comparison.

  • Hanna Spivack

    This give me a SUM of the tickets, I need a report that shows me the AVG amount of tickets created per hour, how can I go about that?

  • Jessie Schutz
    Zendesk Team Member

    Welcome to the Community, Hanna!

    I believe there is an AVG metric that you can use for this; are you not seeing it?

  • Maria Garcia

    Hi, I'm also interested in the AVG of tickets per hour, actually I'm doing a report on the average of tickets created per day of week, but I just keep getting the sum.

  • Jolyon Page

    Hi Maria,

    I replaced # Tickets with a new metric to get the average number of tickets created:

    SELECT AVG(SELECT # Tickets BY Date (Ticket Created))

    Then followed the instructions as in the original post. If you want whole numbers instead of fractions of tickets to be shown, change the metric format to #.

    Hope this helps!

  • Nicole Saunders
    Zendesk Community Team

    Thanks for sharing your answer, Jolyon! We love it when our users can help one another out. 

  • Nicolás Machado


    Is it possible to make a similar report (tickets by hour created or updated) in the native Zendesk report tool? 

    I want to do it so that it shows how many cases we attend out of work hours (according to SLA), but we don't have Insights, and our subscription plan is currently Teams.



Please sign in to leave a comment.

Powered by Zendesk