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

[Nick_VDB]

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

[blasto]

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!