How do I replicate the "Duration Since Last Change[Text Field](hrs)" Insights metric in Explore?

Return to top


  • Mitchell Lewsey
    Zendesk Luminary

    I've checked the recipes link and I can't quite see or figure out how to do what I need.

    I want to know the amount of time spent with the current assignee. I'd guess the formula would be something like:

    The difference between timestamp of NOW and the timestamp of last assignee change. Any tips on how to get this?

  • Dane
    Zendesk Engineering
    Hi Mitchell,
    It seems you have already submitted a ticket (10554425) regarding the same concern and was able to figure out the solution for it. 
    Have a great day!

Please sign in to leave a comment.

Powered by Zendesk