Report content is based on date range - Community / Feature Request - Deskpro Support

New Feature Request

22

Report content is based on date range Finished

Malou

We would like to be able to build reports where you can indicate that the content is based on date range instead of last month or this month as an example.

Comment (1)

Irene Tortorella

acum 5 ani

Hello Malou, by plugging in dates in the "YYYY-MM-DD" format in the WHERE clause of a raw query, it is possible to include any date range.

Example. Total count of tickets created during the second week of June 2018:

SELECT DPQL_COUNT() AS 'Total Count'
FROM tickets
WHERE tickets.date_created >= '2018-06-04' AND tickets.date_created <= '2018-06-10'

If you have any questions do not hesitate to reach out at support@deskpro.com

Best,

Irene

New Feature Request

Author: Malou
Date Created: Nov 14, 2017
Category: Functionaility

Report content is based on date range - Community / Feature Request - Deskpro Support

Report content is based on date range Finished

Comment (1)

Labels