Explore recipe: Displaying tickets answered within different time brackets

Return to top


  • Sarah


    Is it possible to have in the same tab the value in absolute and the values in % of the total (so 2 columns for each range)?


    Thank you!

  • Taylor Bowser
    Zendesk Customer Care

    Hi Sarah, 

    Absolutely! You can duplicate the metric and add both metrics to your query. Then you can go to chart configuration>>display format and change the dropdown of one of these metrics to show as a percentage. 

  • Sarah


    Thanks for your answer but its not what I want to do, I dont want to just change the format, but put the values in % of the total.

    For instance: 

    • 1st column: 5 - 5 - 5
    • 2nd column: 33% - 33% - 33%

    Today Im duplicating the query with the 1st column, and on the second query I go to Result manipulation > Result path calculation > Pattern = % of total

    I would like to have the 2 columns in the same query.

    Thanks a lot!


  • Taylor Bowser
    Zendesk Customer Care

    Hi Sarah, 

    My apologies! You could still apply the same logic here as I mentioned in my previous response. You would want to duplicate your first metric and then add both to the query.

    Lastly, you'll want to go to result manipulation>>result path calculation and change the dropdown to Pattern =  % of total for the second metric. 

  • Sarah

    Fantastic thank you

  • Lucie Lafarge


    Is it possible to maintain the order set in the metric formula ? 
    I can't understant why "1-7 days" and "5 - 24hrs" have their positions exchanges : 

    Thank you


  • Rob Stack
    Zendesk Documentation Team

    Hi Lucie Lafarge, you could possibly use an ordered set to accomplish this. For a starting point, see this recipe - https://support.zendesk.com/hc/en-us/articles/360022367993

  • Trupti

    hi Andrew Forbes,

    How can we create a query for The rate% of the email replied within 60 mins? and we need to view this everyday, is it possible ?

  • Christophe Tiraboschi
    Zendesk Customer Care
    Hi Trupti,
    This is possible.
    After following the recipe of the article, you can create a Group attribute with the value of the First Reply time brackets attribute to get only the 0-1h value and all the other values grouped together.
    You can find more information about Groups in this article:
    You should have something like this:

    Now, when we use this attribute instead of the classic First reply time brackets, we have the following values:

    So if you exclude the NULL and No replies value, you will have the tickets with a reply time of 60 minutes or less and the ones with a reply time over 60 minutes.
    Then you can use the attribute Ticket created - Date to see this for each day. In the example below, I used a table for visualization but you can adapt this to your needs:

    I hope this helps.
  • Shona

    How can I change this recipe to show as Business Hours?  I am assuming the above is reported via calendar hours/days.

    Our business hours a 9am-5pm.

  • Dane
    Zendesk Engineering
    Hi Shona,
    You can use business hours by creating a new First Reply Time Bracket attribute. Instead of the normal calendar days in the formula, business days will be used. Refer to the screenshot below.

    Just go to Calculations > Standard Calculated attribute and use this formula:
    IF (VALUE(First reply time - Business hours (min)) <= 60)
    THEN "0-1 hrs"
    ELIF (VALUE(First reply time - Business hours (min)) <= 60*8)
    THEN "1-8 hrs"
    ELIF (VALUE(First reply time - Business hours (min))>60*8 AND VALUE(First reply time - Business hours (min)) <= 60*24)
    THEN "8-24 hrs"
    ELIF (VALUE(First reply time - Business hours (min)) > 60*24)
    THEN ">24 hrs"
    ELSE " No replies"
    It should now give you the time brackets in business hours.
    Hope this helps.
  • AMU Cx Lead

    I'm attempting to build a query that calculates the number or tickets received outside of our business hours (evenings and weekends).  I would like for the tickets received during our off hours to appear as sorted by the hour and as a different color for during our hours as opposed to outside of them.  I'm using a Standard calculated attribute, but get lost with the formatting of the result.

    "IF (IN([Ticket created - Day of week],ARRAY("Monday", "Tuesday","Wednesday","Thursday","Friday")))
    AND (IN([Ticket created - Hour],ARRAY("8", "9", "10", "11", "12", "13", "14", "15")))

  • Dane
    Zendesk Engineering
    @AMU Cx Lead,
    Formatting of the actual metric is not supported. However, you can format the result that was extracted if you are using the Table Visualization. For more information, you can refer to Adding Conditional Formatting for tables.
  • AMU Cx Lead

    I have another question about building a different query than of the above.  I'm attempting to calculate the percentage of tickets "touched" by an agent, which is also received outside of our business hours.  Meaning that if we receive 80 tickets between 5pm on Friday and 8 am on Monday, I can identify that of that 80, an agent responded to 10%, and that 8% were solved while 2% was marked as pending?

    Does that make sense?


  • Prathiba Sugumar

    I am having a very basic report to display the Full Resolution Time brackets and First Resolution Time Brackets. As per the definition - "The time between when the ticket was first opened, and the first time / last time it was set to solved"

    But the report that I have includes several tickets - that has never been set to 'Solved' even once. What could be the reason here? 

  • Christine
    Zendesk Engineering
    Hi Prathiba,

    I see that you already have an ongoing ticket related to this question with our support team. We'll continue to assist you from there. Thank you!
  • bill cicchetti

    Hello All,

    Wonder if someone could direct me in the right direction. I am trying to create a report showing the average resolution time for tickets closed within certain time brackets such as :

    Last 7 days:   Avg time for closed “Tier Dev”  assigned tickets

    Last 15days: Avg time for closed “Tier Dev”  assigned tickets

    Last 30days: Avg time for closed “Tier Dev”  assigned tickets

    I've been trying to use the following formula which gives me a green approval check when I created it but when used in a report it said here is a problem calculating this field:

    Im trying to use the datedif and NOW(0) options similar to this:

    If (DATE_DIFF([Ticket solved - Date],NOW(),"days") <= 5)
    THEN "5 days or less"
    elif (DATE_DIFF([Ticket solved - Date],NOW(),"days") >= 5)
    THEN "5 days or greater"


    Above is just a snippet from the test custom attribute and not the final formula.

    When I open the attribute to filter the results I only see the following:

    Any suggestions?

  • Alex Zheng
    Zendesk Customer Care
    Hey Mayra,
    If you click on this eyeball icon it will open up the attribute where you can see the formula being used and you can use this and create your own time brackets by simply just changing the numbers used in the formula.

    Hope that helps!

Please sign in to leave a comment.

Powered by Zendesk