Hello @paIoaItonetworks ,
Thanks for reaching out on LiveCommunity!
Below is a reference query which you can use and build up your use case. It gives you Time to assignment of incidents and Time to resolution of incidents.
dataset = incidents | alter TimeToAssign = timestamp_diff(first_assignment_ts ,creation_time,"MINUTE") | alter HourToResolve = timestamp_diff(resolved_ts,creation_time,"HOUR") | alter MinToResolve = timestamp_diff(resolved_ts,creation_time,"MINUTE") | fields creation_time , resolved_ts , first_assignment_ts ,TimeToAssign , HourToResolve , MinToResolve
Please click Accept as Solution to acknowledge that the answer to your question has been provided.
... View more