Explore recipe: Creating a ticket first reply date attribute

Return to top
Have more questions? Submit a request

9 Comments

  • Amanda Gunn

    Hi Eugene Orman

    How do you write this if you want the field to appear NULL or with some written text like "No first reply yet" when there has not been a first reply on the ticket? I created this attribute and used the date only formula, but for questions without a first response it is just putting in the date of when the ticket is created which is inaccurate.

     

    Thanks,

    Amanda

    0
  • Brett Bowser
    Zendesk Community Team

    Hey Amanda,

    I saw you already had a ticket open with our Customer Advocacy team regarding a similar query. Were you able to get your question answered from an Advocate?

    Let me know if there's anything else we can assist with.

    Cheers!

    0
  • Philip Crump

    Hi there,

     

    Thank you for the helpful metric. I am using the date formula that you supplied, and I have confirmed that it works on most of the data. However we have seen strange behaviour whereby it will actually show the first reply date as being in the future.

    In the table below you can see at the bottom that a ticket has been created on 3rd June, and yet it says the first reply was on the 3rd of August. Looking at the ticket itself I can see that it actually received it's first reply on the 6th July. I'm wondering how the calculation may have made this mistake?

    Another example is two tickets created on the 13th June, that the calculation says their first reply is on the 25th July (in the future). Yet one of these tickets was closed and merged with another, so never had a first reply, and the other was responded to on the 6th July. 

     

    Are you able to shed any light on why the calculation might be doing this?

     

    Thank you

    0
  • Philip Crump

    I have found the issue! For tickets created with the exact same timestamp, the calculation seems to add their first reply times together. Do you think there is a way around this?

    0
  • Devan - Community Manager
    Zendesk Community Team

    Hello Philip Crump,

    After looking into this and talking w/ a few of our experts on this subject, it does seem like some unexpected behavior is taking place. Right now, one of our specialists is looking into this issue and has reached to you via ticket. Once she has more information on this, she will reach out to you, but for now, we appreciate your patience with this snafu. 

    Best regards. 

    0
  • Jason Brown

    In Explore, if there a way to create a report that has the following Attribute and Metric? 

    Ticket Problem ID

    First Ticket Created Timestamp

     

    We are trying to create a report where we can see when the first incident was created for each problem ticket.

    0
  • Brett Bowser
    Zendesk Community Team

    Hey Jason,

    This recipe may help point you in the right direction! Explore recipe: Measuring the number of incidents by problem

    You can then apply the Time - Ticket created attribute to your report.

    I hope this points you in the right direction!

    0
  • Richard H Dawson II

    How would you write this if you wanted to group your First reply time by the week of the year.  I want to see the reply time for the tickets updated each week so if a ticket gets opened on a Friday night.  We won't respond to it until Monday which is the following week.  Otherwise, when I report the week's response times it will change later on that day and it will make my reporting look in accurate.

    0
  • Hannah Meier
    Zendesk team member

    Hello Richard H Dawson II,

    You can do this by changing the last part of the formula, which formats the date. For example, if you want this formula to show the year and week number, you can change the formula to this:

    IF (VALUE(First reply time (min))!=NULL)
    THEN DATE_FORMAT(DATE_FROM_TIMESTAMP(DATE_TO_TIMESTAMP([Ticket created - Timestamp])+VALUE(First reply time (min))*60),"ww yyyy")
    ELSE "-"
    ENDIF

    Here is a link to an article that describes the values you can use in the DATE_FORMAT() function:

    0

Please sign in to leave a comment.

Powered by Zendesk