Howdy, this is a modification of one of the standard reports, but I cannot seem to get the right code so that it only counts tickets of a specific type. for example we only want it to be for 'IT Helpdesk' type tickets.
Select Top 1000000 DatePart(yyyy, htblticket.date) As Year,
DatePart(mm, htblticket.date) As Month,
DatePart(dd, htblticket.date) As Day,
Count(htblticket.ticketid) As TicketsCreated
From htblticket
Where htblticket.spam <> 'True'
Group By DatePart(yyyy, htblticket.date),
DatePart(mm, htblticket.date),
DatePart(dd, htblticket.date)
Having Max(htblticket.date) > GetDate() - 7
Order By Year Desc,
Month Desc,
Day Desc
