Time spent per ticket type per month

[Beretta031]

Hello, 

I am looking for a report that can filter by ticket type and by month and THEN time spent on average for the month on said ticket type. 

[FrankSc]

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)