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, htblticket.date) As Year,
DatePart(mm, htblticket.date) As Month,
htbltickettypes.typename Type,
htblusers.name 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 =
htblticket.tickettypeid
Group By DatePart(yyyy, htblticket.date),
DatePart(mm, htblticket.date),
htbltickettypes.typename,
htblusers.name
Order By Year Desc,
Month Desc,
Type,
AssignedAgent
I tried modifying this script from
here, but failed miserably.
Could anyone show me the light please?
As always, thanks in advance.
Tim
