Hi Toliev,

You should be able to do this through the WHERE clause.

A simple example might be to use the below to count the number of tickets raised in the support department:

SELECT DPQL_COUNT() AS 'Number of tickets raised in the support department'
FROM tickets
WHERE tickets.department.title = 'Support'

You could also use a variable to add departments to a dropdown which you can select from.

The base report would be:

SELECT DPQL_COUNT() AS 'Number of tickets raised in the support department'
FROM tickets
WHERE tickets.department.id = ${department}

And then you could add the variable with TYPE = Value and RECORD Type = Department

For more on using variables check out our documentation below:
https://support.deskpro.com/en-GB/guides/reports-guide/pull-down-menus-2