The Hydrus pivot table allows users to explore consumption and emissions data in a flexible way.
Instead of reviewing individual records one by one, users can group and summarize data by facility, location, reporting period, scope, category, and other available fields.
This makes it easier to compare results, review totals, identify patterns, and examine detailed emissions figures within a calculation.
Select the calculation source
Start by choosing the calculation you want to analyze.
Use the Calculation Source dropdown to select the calculation that contains the relevant consumption and emissions data.
Once selected, the pivot table will use that calculation as the basis for the analysis.
This ensures that all groupings, metrics, and summaries shown in the table relate to the calculation you want to review.
Configure row grouping
The Row Grouping section determines how the data is organized.
Users can select one or more fields and arrange them in the order that best supports the analysis.
Available fields may include:
- Facility
- Facility Type
- Location
- Year
- Period
- Unit
- Scope
- Category
- Other available dimensions
For example, grouping first by Facility and then by Period allows users to review how results change over time for each location.
Changing the order of the fields changes how the pivot table groups and displays the data.
Select metrics and aggregations
The Columns section controls which values are displayed in the pivot table.
Users can select measures such as:
- Consumption
- Carbon Emissions
For each measure, an aggregation method can also be selected.
Available options may include:
- Sum
- Average
- Count
- Minimum
- Maximum
The aggregation method should match the purpose of the analysis.
For example, Sum can be used to review total consumption or emissions, while Average can be used to compare typical values across a group of records.
Minimum and Maximum can help identify the lowest and highest values within a selected group.
Review and sort the results
After configuring the pivot table, review the resulting dataset.
The table can show data grouped by scope, consumption category, emissions category, facility, period, and other selected dimensions.
Consumption values can be reviewed alongside the related carbon emissions, making it easier to compare activity and emissions within the same view.
Sorting options can be used to organize the results by:
- Value
- Category
- Scope
- Facility
- Reporting period
- Other available fields
Sorting can help users quickly identify the largest values, compare locations, or focus on specific parts of the dataset.
Analyze detailed emissions data
Once the grouping, metrics, and sorting are configured, the pivot table can be used for more detailed analysis.
Users can review emissions and consumption at a granular level and compare results across different parts of the organization.
This can support activities such as:
- Comparing facilities
- Reviewing changes between reporting periods
- Identifying high-consumption activities
- Examining emissions by scope or category
- Checking calculation results
- Investigating unusual values
The level of detail shown depends on the selected row groupings and metrics.
A more detailed grouping provides a more granular view, while fewer grouping fields provide a higher-level summary.
Use the pivot table for focused analysis
The pivot table provides a flexible way to move between high-level summaries and detailed reporting data.
By changing the calculation source, row groupings, metrics, aggregation methods, and sorting options, users can adjust the table to match the specific question they want to answer.
This makes it easier to review consumption and emissions data without changing the underlying calculation.
A well-configured pivot table can help users compare results, identify significant values, and understand how emissions are distributed across facilities, periods, scopes, and categories.