cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Helpdesk: Count of tickets created per year and month (Built-in)

Nick_VDB
Champion Sweeper III
Added in v.6.0.100

The report below gives back a count of the tickets that have been created during each year/month.

The report will only take count tickets that meet all of the following criteria:
  • The ticket has not been set to ‘Ignore’


Select Top 1000000 DatePart(yyyy, htblticket.date) As Year,
DatePart(mm, htblticket.date) As Month,
Count(htblticket.ticketid) As TicketsCreated
From htblticket
Where htblticket.spam <> 'True'
Group By DatePart(yyyy, htblticket.date),
DatePart(mm, htblticket.date)
Order By Year Desc,
Month Desc
1 REPLY 1

blasto
Engaged Sweeper III
Nick.VDB wrote:
Added in v.6.0.100

The report below gives back a count of the tickets that have been created during each year/month.

The report will only take count tickets that meet all of the following criteria:
  • The ticket has not been set to ‘Ignore’


Select Top 1000000 DatePart(yyyy, htblticket.date) As Year,
DatePart(mm, htblticket.date) As Month,
Count(htblticket.ticketid) As TicketsCreated
From htblticket
Where htblticket.spam <> 'True'
Group By DatePart(yyyy, htblticket.date),
DatePart(mm, htblticket.date)
Order By Year Desc,
Month Desc


Thank you so much!