Added in v.6.0.100
The report below lists the percentages of tickets that have come into the helpdesk based on the source of the ticket and the month/year.
The report will only list tickets that meet all of the following criteria:
- The ticket has not been set to ‘Ignore’.
Select Top 1000000 DatePart(yyyy, htblticket.date) As Year,
DatePart(mm, htblticket.date) As Month,
htblsource.icon As icon,
htblsource.name As Source,
Count(htblticket.ticketid) As TicketCount,
Cast((Count(htblticket.ticketid) / Cast(TicketCount.Amount As decimal) *
100) As decimal(10,2)) As [Source%]
From htblticket
Inner Join htblsource On htblsource.sourceid = htblticket.sourceid
Inner Join (Select DatePart(yyyy, htblticket.date) As Year,
DatePart(mm, htblticket.date) As Month,
Count(htblticket.ticketid) As Amount
From htblticket
Where htblticket.spam <> 'True'
Group By DatePart(yyyy, htblticket.date),
DatePart(mm, htblticket.date)) As TicketCount On TicketCount.Year =
DatePart(yyyy, htblticket.date) And TicketCount.Month = DatePart(mm,
htblticket.date)
Where htblticket.spam <> 'True'
Group By DatePart(yyyy, htblticket.date),
DatePart(mm, htblticket.date),
htblsource.icon,
htblsource.name,
TicketCount.Amount
Order By Year Desc,
Month Desc,
Source
