For organizations that only provide support during Monday to Friday, it makes sense to exclude data from the weekend in reports to accurately develop a picture of helpdesk performance.

If you'd like to create a report that excludes tickets that were created at the weekend, add the following to the WHERE line in your DPQL query

WEEKDAY(tickets.date_created) NOT IN ('5', '6')

As you can see, this sets conditions on which days of the are included in the report by excluding 5 = (Saturday), and 6 = (Sunday).

For example, here is a an example of a report which will give you a list of tickets created in October, grouped by agent, whilst excluding tickets created on the weekend.