Average Ticket Resolution Time (SQL Query)
has anyone a query that gets the average resolution time of all incidents? I already got one but i need to exclude the non business hours and weekends.
AVG(Cast(DateDiff(minute, [Created], [ResolvedDate]) as bigint)) as AverageDuration
WHERE ResolvedDate not like 'NULL'