Skip to main content


List of functions

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


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


In this instance 29.11 %.

Authors list

First published: 18/07/2019

Last updated: Jul 26, 2019 by Matthew Wray