Aggregation Dataset
- Zhanar (Unlicensed)
- Anastasia Baranouskaya
Aggregation dataset is a dataset into which lower-level units provide data for data aggregation on higher-level units. Based on aggregation datasets, custom aggregated metrics are created that allow you to get a comprehensive view of the progress of lower-level units that provide data to the aggregation dataset.
Prerequisites
As a user operating with aggregation datasets, ensure that the following conditions are met:
You have the Aggregation Admin permissions.
You are on high-level unit.
1. Create Aggregation Dataset
On the main menu, click Perf, and then open the required high-level unit and open the Delivery Metrics tab
Click Add → Metrics on the Delivery Metrics. The Metric Catalog is opened.
3. Find Custom Aggregated Metrics category in the left navigation menu.
4. Click Create New Aggregated Metric button in the menu.
5. Open step. 2 and find Aggregation Datasets category in the left navigation menu and click Create New Aggregation Dataset button in the menu. Create Aggregation Dataset page is opened.
Note
Only 17 fields can be added to an Aggregation Dataset.
Note
The application adds such system fields to the aggregation dataset as:
unit_external_id
unit_name
unit_type
These system fields can be used when building a PerfQL Query for an aggregated metric
Field name restrictions
Note
Fields must have a unique name in scope of one aggregation dataset.
Field name must start with a letter or underscore.
Allowed characters: A-Z, a-z, 0-9, _ (underscore).
Field cannot be named as system fields: unit_external_id, unit_name, unit_type.
Field cannot be named as PostgreSQL reserved text. See Table C.1. SQL Key Words for reserved PostgreSQL texts. PostgreSQL: Documentation: 15: Appendix C. SQL Key Words)
2. Delete Aggregation Dataset
To delete Aggregation Dataset from PERF:
Open required high-level unit on the Delivery Metrics tab.
Click Add → Metrics on the Delivery Metrics. The Metric Catalog is opened.
Find Custom Aggregated Metric category in the left navigation menu and click Add New Custom Aggregated Metric.
Open step 2 and find Aggregation Datasets category in the left navigation menu
Click the 3-dots menu for the necessary dataset and click Delete.