Overview

If standard PERF datasets doesn't meet your requirements, create custom data selection over PERF data using PERF Query Language (PerfQL, based on SQL).

To open it, go to Metric Catalog → Custom Metrics → Add Your Metric → click on Table field → Custom Selection → Edit.

"Select Data" has three main sections:

• The Guide shows list of available datasets and their fields (see PERF Datasets).

• The PerfQL Query allows to transform datasets to achieve your final result set.

• The Result Preview shows the result set for the PerfQL Query (first 100 records). 

PerfQL Query

PerfQL is built on SQL and provides powerful techniques for data manipulation. It allows you to create advanced custom metrics with formula-like expressions with selecting, joining, filtering, and aggregating your data.

Write PerfQL statements in the "Edit area" to generate new datasets.

In case there are any syntax errors, the area will display an error message.

PerfQL for JSON type of fields

To build a custom metric with data which is stored in JSON form, select nessesary data from JSON in the Delivery Central → Perf → Custom Metrics → Select Data:

1. Open Developer Tools in your browser and open Network tab;

2. Insert PerfQL with the JSON field, for example: select custom_fields from Ticket;

3. Click Reload;

4. Click on the sample-data in the console;

5. Open Responce tab.

Response tab has list of all custom fields and their data.

Find nessesary field in the Response and copy it name. Then use function json_array_elements(json) and select this field with value as separate column togather with other nessesary fields.

Result Preview

To preview data based on your PerfQL request, click the Reload button and you’ll see the result table in the Result Preview area. 

If there is no data to calculate (e.g., the data source was not configured or was removed), the area will display "No Data" message.