Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-19-2019 09:40 PM
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
Labels:
- Labels:
-
Report Center
0 REPLIES 0
