Question
Insights has a metric called Duration Since Last Change[Text Field](hrs). Where do I find that metric in Explore? I need to replicate my Insights reports in Explore that have that metric.
Answer
There is not an equivalent metric in Explore to the Duration Since Last Change [Text Field] (hrs) Insights metric. You can create any version of that metric that you might need by following this recipe: Reporting on the duration of fields.
3 comments
Mitchell Lewsey
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
Dane
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
James Peterson - Eastern Logic
Hi Mitchell Lewsey ,
Any chance you could post your solution here? We are looking for something similar now.
0