Explore recipe: Tickets by time of day created

Return to top


  • Kayla Valadez


    First time taking a stab at these dashboards. Is there a way to edit the hour/time format to not read as 0 through 23? 

  • Chandra Robrock
    Community Moderator
    Most Helpful - 2021

    Hey Kayla Valadez - You can definitely adjust this by creating two new calculated attributes.

    For instance, here's what I've done in the past. First, I created a Renamed Set calculation based on the Ticket Created - Hour attribute. This allows me to rename the values 0 through 23 to the actual hour they represent in our Zendesk instance. Here's a screenshot of what that looks like:

    Next, I created a new Ordered Set calculation based on the newly built Renamed Set calculation to help control how these attributes will be ordered for a query. For instance, 1am, 2am, 3am, 4am, etc. instead of 1am, 1pm, 2am, 2pm, etc. Here's what that looks like:

    From there, select the name of the Ordered Set you created under the Columns section and you should be all set. You'll also be able to use these new calculated attributes for any other queries you'd like to build. Hope that helps!


Please sign in to leave a comment.

Powered by Zendesk