DPQL_PERCENT

List of functions

DPQL_PERCENT allows us to check the percentage of a group that meets a specified condition.

Example

We'd like to check the Percentage of tickets that have been submitted to our helpdesk that have been resolved.

To do this we simply run the query below

SELECT DPQL_PERCENT(tickets.status IN ('resolved', 'archived')) AS 'Percentage of tickets resolved'
FROM tickets

The query finds the total number of statuses in 'tickets' and then calculates the percentage of these that match the condition specified 'tickets.status IN ('resolved', 'archived')'

image.png

In this instance 29.11 %.

Published: 18/07/2019

Last updated: 26/07/2019