Making a report

DPQL Reference

To create a report from scratch, go to Reports > Stat Builder > Add

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

Using stats

In the stat builder, you can see a list of existing stats, complete with labels. You can filter stats here by name or label.

To interact with a stat, click on it.

In the stat pane, you can see the the data values the stat is showing based on the DPQL queries associated with it.

image.png

You can also edit the DPQL values of the stat by clicking the Edit Stat button.

To create a new stat, click the + Add 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.

Published: 23/03/2018

Last updated: 22/05/2018