To create a report from scratch, go to the Stats tab and select + Create Statistic.

What are Stats?

Stats are sets of data values that can be displayed in a variety of different formats. You can combine multiple stats together to create reports, and multiple reports to create dashboards.

Stats in Deskpro are built using DPQL, a structured query language. Each DPQL query you make pulls specific data from your helpdesk and displays it in the specified format.

For more information on using DPQL, refer to our DPQL Guides.

Using Stats

In the Navigation Panel, you can see a list of your built-in and existing stats, with numbers indicating the number of stats you have per category. You can search for stats here by name, or sort them alphabetically or by number of stats.

To interact with a stat, select the category and click on it.

You can see the the data values the stat is showing based on the DPQL queries associated with it. You can also edit the DPQL values of the stat by clicking the Edit Stat button.

To create a new stat, click the + Create Statistic button.

Enter a title for your stat, and add any labels you wish to associate it with.

Whether editing or creating a new stat, you will be required to use DPQL queries to specify the data you want to see in the stat.

The query builder provides a guided process so you simply need to fill in the values, but raw DPQL allows you to input both clauses and values if you wish.