Skip to main content

How do I generate a report that doesn't include tickets created on the weekend? - Using Deskpro - Deskpro Support

How do I generate a report that doesn't include tickets created on the weekend?

Authors list

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

AND DAYOFWEEK(tickets.date_created) NOT IN ('1', '7')

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

For example, here is a an example of a report which will give you the number of tickets created any time, grouped by department and agent, whilst excluding tickets created on the weekend.

For more information on how to create reports and build queries, refer to our guide on the anatomy of a DPQL query.

Hyödyllinen Hyödytön

Henkilöt, jotka pitivät tätä sivua hyödyllisenä: 1 / 1

Lisää kommentti

Please log in or register to submit a comment.

Need a password reminder?