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

WARNING: You're browsing documentation for an older version of Deskpro. For the most up-to-date version, see: How do I generate a report that excludes Tickets created on the weekend?

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

Voor het laatst bijgewerkt door: 29 aug 2023 door Lara Proud

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).

Note

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.

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

Behulpzaam Niet nuttig

22 van 34 mensen vonden deze pagina nuttig

Reactie toevoegen

Auteur: Benedict Sycamore
Last update: 29 aug 2023