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.
PerfQL Rules
Only Select statements.
Only one root statement per query.
Only specified list of functions could be used (list of supported functions).
Only specified list of datasets (tables and fields) could be used (list of allowed datasets).
See examples of PerfQL Quries for different cases
In case there are any syntax errors, the area will display an error message.
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:
Result preview is read-only and displays only first 100 records but metric will be calculated for all available data.
Copyright © 2024 EPAM Systems, Inc. |
---|
All Rights Reserved. All information contained herein is, and remains the property of EPAM Systems, Inc. and/or its suppliers and is protected by international intellectual property law. Dissemination of this information or reproduction of this material is strictly forbidden, unless prior written permission is obtained from EPAM Systems, Inc. |