Duration between each updated timestamp And timestamp's order

Answered

4 Comments

  • Hillary Latham
    Community Moderator

    (1) you should be able to do this with the DATEDIFF function - what did you try that didn't work?

    (2) I don't know of a way to compare data from other rows in a row in Explore.  With that limitation, you can sort and utilize min and max functions with metrics.  Can you create a metric out of what you are trying to do and then utilize the features available for metrics to get what you are after?  For example, if you create a metric that used DATEDIFF to subtract the current date and time from the Update Timestamp, you would have values that sort the same way as the time stamp and you could have MIN and MAX values display in the columns.

    0
  • Hillary Latham
    Community Moderator

    @..., I just came across this article, which has some functions that may help with #2. https://support.zendesk.com/hc/en-us/community/posts/1260802261709

     

    0
  • Dream

    Thank you @... I will try DATEDIFF function but I'm a bit confused how to use it.

    0
  • Hillary Latham
    Community Moderator

    Hey @..., this recipe uses the DATE_DIFF function.  It's not quite the same as what you are after, but you would just swap out "today()" in the recipe with the Update Timestamp.  https://support.zendesk.com/hc/en-us/articles/1260801911090-Explore-recipe-Tracking-length-of-service-of-your-agents

    0

Please sign in to leave a comment.

Powered by Zendesk