Streamlining Data in the "Consolidation" Environment: Aggregating ESG Metrics
The "Consolidation" section is where you can aggregate data points, combining multiple inputs into a single, cohesive ESG metric. This environment simplifies the process of summarizing data across different time periods or dimensions, ensuring accurate reporting of key sustainability metrics.
How It Works
In this section, individual data points are aggregated once their contributing data points have been filled. A data point remains independent until all relevant data points are completed.
Consolidation is available only for numerical or table-based KPIs and will be based on two types of aggregation:
Types of Aggregations
-
Temporal Aggregation (Time-Based)
- This type of aggregation combines data over time, allowing you to summarize metrics over specific periods.
-
Dimensional Aggregation (Based on Dimensions)
- This approach aggregates data based on specific dimensions such as country, department, or region.
Aggregation Operations
When consolidating data, you can select from various operations, depending on how you want to aggregate the information. These operations include:
- Sum: Adds up all data points.
- Max (Maximum): Selects the highest value from the data set.
- Min (Minimum): Selects the lowest value from the data set.
- Average (Mean): Calculates the average of all data points.
Example
For example, to calculate the Aggregate Consumption of Water by country, you would use Dimensional Aggregation based on the dimension “country” and apply the Sum operation to get the Global Consumption of Water.
If you still have doubts and need to get in touch with our customer success team, please reach out to "support@aplanet.org" and you will be attended as soon as possible.