SageMaker Mean-Time-To-Response (MTTR)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

select
  --q.Id as [Post Link] -- comment out to get MTTR aggregate
  count(distinct q.Id) as postcount, --comment out to list all Qs
  round(cast(avg(cast(datediff(second, q.CreationDate, a.CreationDate) as bigint)) as float)/3660,2) as [MTTR_hours] --comment out to list all Qs
from posts q, posts a, posthistory ah
where a.ParentId = q.Id -- match questions answers
  and ah.PostId = a.Id -- consider answer's history
  and ah.PostHistoryTypeId = 2 -- answer post must be text
  and datediff(second, q.CreationDate, a.CreationDate) > 0
--  and a.OwnerUserId <> q.OwnerUserId -- not self answered
  and q.Tags like '%<##tag?amazon-sagemaker##>%'
  and q.CreationDate >= '2021-10-01'
  and q.CreationDate < '2021-10-31'

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results