Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-09-2017 01:05 PM
Added in v.6.0.100
The report below lists the percentages of tickets that have come into the helpdesk based on the type of the ticket and the month/year
The report will only list tickets that meet all of the following criteria:
The report below lists the percentages of tickets that have come into the helpdesk based on the type 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,
'../helpdesk/icons/' + htbltickettypes.icon As icon,
htbltickettypes.typename As Type,
Count(htblticket.ticketid) As TicketCount,
Cast((Count(htblticket.ticketid) / Cast(TicketCount.Amount As decimal) *
100) As decimal(10,2)) As [Type%]
From htblticket
Inner Join htbltickettypes On htbltickettypes.tickettypeid =
htblticket.tickettypeid
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),
htbltickettypes.typename,
htbltickettypes.icon,
TicketCount.Amount
Order By Year Desc,
Month Desc,
Type
Labels:
- Labels:
-
Built-In Reports
-
Report Center
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-13-2017 01:54 AM
Hello,
Does anyone know how to modify this report to do a count of tickets closed per agent per month?
Thanks.
Does anyone know how to modify this report to do a count of tickets closed per agent per month?
Thanks.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-15-2017 09:42 PM
Hello Nick,
This code is the same as the other post titled "Helpdesk: Count of tickets per source, this month (Built-in)". I ran both codes from each code and the results were identical. Can this be corrected?
Thanks.
This code is the same as the other post titled "Helpdesk: Count of tickets per source, this month (Built-in)". I ran both codes from each code and the results were identical. Can this be corrected?
Thanks.