Explore recipe: Tickets by time of day created

Have more questions? Submit a request


  • Chris Hanson
    Comment actions Permalink

    Hi There,

    Is there a simple way to change the X Axis to display a 12 hour format? For example, "13" would display as 1:00 PM?

  • Rob Stack
    Comment actions Permalink

    Hi Chris, there isn't (to the best of my knowledge) a simple option that can change the displayed values, but there is something called 'renamed sets' that can do this, I've learned a little about it and put together a recipe. I promise it's a little easier than it looks at first glance!


    I hope this helps!

  • Chris Hanson
    Comment actions Permalink

    Hey Rob,

    Brilliant, this is exactly what I was looking for!

  • John Cason
    Comment actions Permalink

    Thanks for sharing how to change it to non-military time! Very helpful!

  • Kamolchanok Jittrepit
    Comment actions Permalink

    As this article, if I filtered Ticket created - Year (Selected 2019) and Column Ticket created - Hour, will the chart display an average Ticket created - Year of 2019?

  • Brett - Community Manager
    Comment actions Permalink

    Hey Kamolchanok,

    If you selected 2019, then your report would show the distribution by the hour of tickets created, for all tickets in your account created in 2019. This wouldn't show the average tickets created during that hour but the total tickets created during that hour.

    Let me know if the above doesn't make sense!

  • Devan
    Comment actions Permalink

    On Wednesday, April 8, from 8:00am-10:00pm CDT, we'll have a special guest team of experts on hand to answer your questions about Explore: Reporting & Insights Migration in your Zendesk Explore instance for an AMA-style conversation!

    Just click the "new post" button and write up your question. Be sure to be as detailed as possible. The best questions include: 

    • What it is you're trying to do
    • What you've tried so far 
    • Any other context or relevant information
    • Screenshots, if you have them

    Questions posted to this topic in advance of the start time will be answered first thing on the 8th, so if you've got something you want our experts to look at, post it today!


Please sign in to leave a comment.

Powered by Zendesk