Find the Number of Helpdesk Tickets Finished per Month
Report on the number of tickets that were handled in a given month. Keeping track of the number of tickets that come through the helpdesk is an important metric when it comes to forecasting and for estimating the amount of work. The report gives an overview of the number of closed tickets per year and month. This way you have proof of the number of tickets finished which can be incorporated in a monthly review.
Count of Tickets Closed per Year and Month Query
Select Top 1000000 TicketClosures.Year,
TicketClosures.Month,
Count(TicketClosures.ticketid) As TicketClosed
From (Select Distinct Top 1000000 htblhistory.ticketid,
DatePart(yyyy, htblhistory.date) As Year,
DatePart(mm, htblhistory.date) As Month
From htblhistory
Inner Join htblhistorytypes On htblhistorytypes.typeid =
htblhistory.typeid
Inner Join htblticketstates On htblticketstates.ticketstateid =
htblhistory.ticketstateid
Where htblhistorytypes.name In ('Status changed',
'Note added and state changed', 'Internal note added and state changed')
And htblticketstates.statename = 'Closed') TicketClosures
Inner Join htblticket On htblticket.ticketid = TicketClosures.ticketid
Where htblticket.spam <> 'True'
Group By TicketClosures.Year,
TicketClosures.Month
Order By TicketClosures.Year Desc,
TicketClosures.Month Desc
