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