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).
0 = Monday, 1 = Tuesday, 2 = Wednesday, 3 = Thursday, 4 = Friday, 5 = Saturday, 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.
![](https://support-attachments.deskpro.com/20067/20066897BNQWCZKMCJZBXNX0-image.png)
Přidat komentář
Please log in or register to submit a comment.