Hello,
We found the following report in another post, this may be a good report to start from and add additional filters specifically for your ticket types.
Select Top 1000000
htblticket.ticketid As ID,
htblticket.subject As Subject,
htblticket.updated As [Closed Date],
AVG(htblnotes.timeworked) As [Average Time Worked (Minutes)],
htblusers.name As Agent,
htbltickettypes.typename As [Ticket Type],
DatePart(mm, htblticket.updated) As Month,
DatePart(yy, htblticket.updated) As Year
From
htblticket
Inner Join
htblnotes On htblticket.ticketid = htblnotes.ticketid
Inner Join
htblagents On htblagents.agentid = htblticket.agentid
Inner Join
htblusers On htblusers.userid = htblagents.userid
Inner Join
htblticketstates On htblticketstates.ticketstateid = htblticket.ticketstateid
Inner Join
htbltickettypes On htblticket.tickettypeid = htblticket.tickettypeid
Where
htblticketstates.statename = 'Closed'
Group By
htblticket.ticketid,
htblticket.subject,
htblticket.updated,
htblusers.name,
htbltickettypes.typename,
DatePart(mm, htblticket.updated),
DatePart(yy, htblticket.updated)
