Duration between each updated timestamp And timestamp's order

(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.

@Kamolchanok Jittrepit, 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

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

Hey @Kamolchanok Jittrepit, 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