Explore recipe: Displaying tickets answered within different time brackets

Return to top

14 Comments

  • Sarah

    Hello!

    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!

    0
  • 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. 

    0
  • Sarah

    Hello,

    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!

     

    0
  • 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. 

    1
  • Sarah

    Fantastic thank you

    0
  • Lucie Lafarge

    Hello, 

    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

     

    0
  • 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

    0
  • 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 ?

    0
  • 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.
    0
  • 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.

    0
  • 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"
    ENDIF
     
    It should now give you the time brackets in business hours.
     
    Hope this helps.
     
    Cheers,
    Dane
    0
  • 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")))
    THEN TRUE 
    ELSE FALSE
    ENDIF"

    0
  • 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.
    0
  • 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?

     

    1

Please sign in to leave a comment.

Powered by Zendesk