Aggregation Dataset

Owned by Zhanar (Unlicensed), created
Last updated: Oct 30, 2023 by Anastasia Baranouskaya
3 min read

 

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:

  1. You have the Aggregation Admin permissions.

  2. You are on high-level unit.

1. Create Aggregation Dataset

  1. On the main menu, click Perf, and then open the required high-level unit and open the Delivery Metrics tab

  2. Click Add → Metrics on the Delivery Metrics. The Metric Catalog is opened. 

Fig1. Delivery Metrics page

3. Find Custom Aggregated Metrics category in the left navigation menu.

4. Click Create New Aggregated Metric button in the menu.

Fig 2. Metric Catalogue

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

  1. Fields must have a unique name in scope of one aggregation dataset.

  2. Field name must start with a letter or underscore.

  3. Allowed characters: A-Z, a-z, 0-9, _ (underscore).

  4. Field cannot be named as system fields: unit_external_id, unit_name, unit_type.

  5. 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: 

 

  1. Open required high-level unit on the Delivery Metrics tab.

  2. Click Add → Metrics on the Delivery Metrics. The Metric Catalog is opened. 

  3. Find Custom Aggregated Metric category in the left navigation menu and click Add New Custom Aggregated Metric.

  4. Open step 2 and find Aggregation Datasets category in the left navigation menu

  5. Click the 3-dots menu for the necessary dataset and click Delete.Â