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
 copy

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