cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
AEMIT
Engaged Sweeper II
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
0 REPLIES 0