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
Hillary Latham
(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
@..., 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
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