Helpdesk: Count of tickets per source and month (Built-in)

[Nick_VDB]

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