Explore recipe: Creating a ticket first reply date attribute

Return to top
Have more questions? Submit a request

13 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
  • vinod

    Hello,

    I want actual first reply datetime, so create below formula based on article 
    https://support.zendesk.com/hc/en-us/articles/360039944933-Explore-recipe-Creating-a-ticket-first-reply-date-and-time-attribute

    "IF (VALUE(First reply time (min))!=NULL AND VALUE(First reply time (min))>0)
    THEN DATE_FORMAT(DATE_FROM_TIMESTAMP(NUMBER(DATE_TO_TIMESTAMP([Ticket created - Timestamp]))+VALUE(First reply time (min))*60),"YYYY-MM-dd HH:mm:ss")
    ELSE "-"
    ENDIF"

    However, it is not working and giving blank values, please help....

    BR,

    Vinod

     

     

    0
  • Eugene Orman
    Zendesk Product Manager

    vinod

    For the timestamp you can use this formula: 

    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),"YYYY-MM-dd HH:MI")
    ELSE "-"
    ENDIF


    However, the date format "MI" syntax is not fully supported. It might be updated in future which will affect your calculation. 

    0
  • vinod

    Thanks Eugene for your reply.

    However, this "MI" addition is not working here.
    Not sure, if this is the correct way to get the actual datetime of first reply.

    0
  • Eugene Orman
    Zendesk Product Manager

    @Vidon, This formula works on my test account. To investigate this issue further will be good to have a look at your query. I have created a ticket for you with our Support team.

    0

Please sign in to leave a comment.

Powered by Zendesk