...
...
| Table of Contents |
|---|
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).
...
| Info |
|---|
PerfQL Rules
|
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:
Open Developer Tools in your browser and open Network tab;
Insert PerfQL with the JSON field, for example: select custom_fields from Ticket;
Click Reload;
Click on the sample-data in the console;
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.
| Note |
|---|
Note: Result preview is read-only and displays only first 100 records but metric will be calculated for all available data. |
| Insert excerpt | ||||||||
|---|---|---|---|---|---|---|---|---|
|
...