Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper III
I have 6 types of tickets, Onboarding and offboarding, IT purchase, Infrastructure IT Support and project.
For all the other tickets I can easily tell why calls are slightly higher or lower, but the IT support one we have differences of 60-100 per month.
I want to be able to just break it down, we have 13 headings under IT support, how can I just run a report against those and just have the subheading from below come up?
I am a SQL dummy, I can bodge things together and sometimes make them work but I think this requires knowledge and finesse, SQL skills I am severely lacking.

I have this script that I thought I could modify to add the additional info from IT support, but I don't have the ability to amend to this code.
Select Top 1000000 DatePart(yyyy, As Year,
DatePart(mm, As Month,
htbltickettypes.typename Type, As AssignedAgent,
Count(htblticket.ticketid) As TicketCount
From htblticket
Inner Join htblagents On htblagents.agentid = htblticket.agentid
Inner Join htblusers On htblusers.userid = htblagents.userid
Inner Join htbltickettypes On htbltickettypes.tickettypeid =
Group By DatePart(yyyy,,
Order By Year Desc,
Month Desc,

I tried modifying this script from here, but failed miserably.
Could anyone show me the light please?
As always, thanks in advance.