Recent searches


No recent searches

Duration between each updated timestamp And timestamp's order

Answered


Posted Apr 23, 2021

I have 2 problems:

1.  I want to calculate duration between Ticket created - Timestamp and Update - Timestamp. How can I do it ? I tried to customize a calculated attribute but seem Explore does not work. 

2. I want to display just the first and last update of each ticket. Are there any way to specify order of updated timestamp?

Note: [---] IT Department Copy is from Changes - New Value


0

4

4 comments

image avatar

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


image avatar

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


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

0


image avatar

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.

Didn't find what you're looking for?

New post