Recent searches


No recent searches

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



image avatar

Elissa Tikalsky

Zendesk Digital Resources Team

Edited Jan 24, 2024


0

3

3 comments

image avatar

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?

0


image avatar

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!

0


Hi Mitchell Lewsey ,

Any chance you could post your solution here?  We are looking for something similar now.

0


Please sign in to leave a comment.