You can build custom PowerReports by using the predefined fields of the monthly dataset.
This topic describes the basic fields that are available in the monthly data set. For information
about user-defined fields such as data type groups, intensity rations and social metrics, see Monthly dataset - Dynamic fields. For information
about advanced fields that are related to specific modules, see Monthly dataset - Advanced fields.
Note:
- All values in the monthly dataset are have applied both consolidation rules and location-group
membership % rules, if they are set up on the platform.
- All previous year fields are defined as current selection minus 12 months.
- To change the global reporting unit for Emissions, Energy, Mass, Volume, go to
. To
change these settings, you must be a system administrator user.
Cost
Table 1. Cost
| Field |
Description |
| Cost |
Total Cost.
Actual Cost + Accrued Cost + Estimated
Cost |
| Cost PY |
Total Cost Previous Year. |
| Cost Rolling 12mth Avg |
Total Cost rolling 12 months average. Note: This field will display the average as at the last
month available in the filtered dataset if no monthly variables are available.
|
| Cost TD |
Total Cost To-Date.
Note: This field will provide the cumulative total cost when used in a table with a calendar field
or the sum of the total cost for the period being reported on if no calendar fields are used.
|
| Cost Variance |
Total Cost variance between current period and same period previous
year.
Cost - Cost PY |
| Cost Variance % |
Total Cost variance between current period and same period previous
year.
(Cost - Cost PY) / Cost PY * 100 |
All values in the cost breakdown subfolder further breakdown the cost values into actual,
estimated and accrued data.
Table 2. Subfolder Cost breakdown
fields
| Field |
Description |
| Accrued Cost |
System generated accrued cost, which is only available if the Accrual feature is turned on.
For more information, see Configuring accruals. |
| Accrued Cost PY |
Accrued cost for the previous year. |
| Actual Cost |
Actual cost being captured in the platform when Estimate flag is set
to No. |
| Actual Cost PY |
Actual cost for the previous year. |
| Estimated Cost |
Cost captured in the system but is flagged as estimated. |
| Estimated Cost PY |
Estimated cost for the previous year. |
| Missing Cost |
An approximation of the cost data missing in an account. |
All cost values in the Global currency unit subfolder table are converted to the global currency
unit as defined for your organization.
Table 3. Subfolder cost fields - in global currency unit
| Field |
Description |
| Accrued Cost Global |
System generated accrued cost, which is only available if the Accrual feature is turned
on. |
| Accrued Cost PY Global |
Accrued cost for the previous year. |
| Actual Cost Global |
Actual cost being captured in the platform when Estimate flag is set
to No. |
| Actual Cost PY Global |
Actual Cost for the previous year. |
| Cost Global |
Total Cost - sum of Actual Cost, Accrued Cost, and Estimated
Cost. |
| Cost PY Global |
Total cost for the previous year. |
| Cost Rolling 12mth Avg Global |
Total cost for a rolling 12 months average. |
| Cost TD Global |
Total cost for the previous year. |
| Cost Variance Global |
Total cost variance between the current period and the previous year. The definition is
Cost - Cost PY. |
| Cost Variance % Global |
(Cost - Cost PY) / Cost PY * 100 |
| Estimated Cost Global |
Cost captured in the system but is flagged as estimated. |
| Estimated Cost PY Global |
Estimated cost for the previous year. |
Emissions
Table 4. Emission
fields
| Field |
Description |
| Emission Variance |
Total GHG emissions variance between current period and previous year, which is equal to
Emissions - Emissions PY. |
| Emission Variance % |
(Emissions - Emissions PY) / Emissions PY * 100. |
| Emissions |
Total GHG emissions is equal to CH4 Emissions + CO2 Emissions + N2O
Emissions. |
| Emissions PY |
Total GHG emissions for the previous year. |
| Emissions Rolling 12mth Avg |
Total GHG emissions for a rolling 12 month average. |
| Emissions TD |
Total emissions to date. The starting period is dynamic and depends on visual
filters. |
| Indirect Emissions |
Indirect emissions such as scope 3 upstream or downstream emissions, which are associated
with the same scope 1 or scope 2 activity data. |
| Indirect Emissions PY |
Indirect emissions for the previous year. |
| Lifecycle Emissions |
Total Lifecycle Emissions is equal to Emissions + Indirect
Emissions. |
| Lifecycle Emissions PY |
Total lifecycle emissions for the previous year. |
| Market-based Emissions |
Market-based emissions of electricity, which are available only when the market-based
reporting methodology is set up on the platform. |
| Market-based Emissions PY |
Market-based emissions for the previous year. |
| Normalized Emissions |
Weather normalized emissions, which are available only when the regression model is set up
for the relevant account or meter. |
All values in the Emissions breakdown subfolder further breakdown the emissions
values into actual, estimated and accrued data and their respective GHG components.
Table 5. Emissions Breakdown subfolder
| Field |
Description |
| Accrued Emissions |
Accrued Emissions Data. |
| Accrued Emissions PY |
Accrued Emissions Date Previous Year. |
| Actual Emissions |
Actual Emissions Data. |
| Actual Emissions PY |
Actual Emissions Data Previous Year. |
| Estimated Emissions |
Estimated Emissions Data. |
| Estimated Emissions PY |
Estimated Emissions Data Previous Year. |
| CH4 Emissions |
CH4 gas emissions in its equivalent CO2e amount. |
| CH4 Emissions PY |
CH4 Emissions Previous Year. |
| CO2 Biogenic Emissions |
BioCO2 gas emissions in its equivalent CO2e amount. |
| CO2 Biogenic Emissions PY |
BioCO2 Emissions Previous Year. |
| CO2 Emissions |
CO2 gas emissions in its equivalent CO2e amount. |
| CO2 Emissions PY |
CO2 Emissions Previous Year. |
| N2O Emissions |
N2O gas emissions in its equivalent CO2e amount. |
| N2O Emissions PY |
N2O Emissions previous year. |
Energy
Table 6. Energy fields
| Field |
Description |
| Energy |
Total Energy (consumed and produced) in the default reporting unit that is set for your
organization. |
| Energy PY |
Total energy for the previous year. |
| Energy Rolling 12mth Avg |
Total energy for rolling 12 months average. |
| Energy TD |
Total energy to date. The starting period is dynamic depending on visual filters. |
| Energy Variance |
Total energy variance between current period and previous year is equal to
Energy - Energy PY. |
| Energy Variance % |
(Energy - Energy PY) / Energy PY * 100 |
| Normalized Energy |
Weather normalized energy. It is available when the regression model has been set up for the
relevant account or meter only. |
All values in this Energy breakdown subfolder further breakdown the energy values into actual,
estimated and accrued data
Table 7. Energy breakdown subfolder
fields
| Field |
Description |
| Accrued Energy |
Accrued energy data. |
| Accrued Energy PY |
Accrued energy date for the previous year. |
| Actual Energy |
Actual energy data. |
| Actual Energy PY |
Actual energy data for the previous year. |
| Estimated Energy |
Estimated Energy Data. |
| Estimated Energy PY |
Estimate Energy Data Previous Year. |
| Accrued Energy in kWh |
Accrued Energy in kWh Data. |
| Accrued Energy in kWh PY |
Accrued Energy in kWh Data Previous Year. |
| Actual Energy in kWh |
Actual Energy in kWh Data. |
| Actual Energy in kWh PY |
Actual Energy in kWh Data Previous Year. |
| Estimated Energy in kWh |
Estimated Energy in kWh Data. |
| Estimated Energy in kWh PY |
Estimated Energy in kWh Data Previous Year. |
Note: All energy values in the Units in KWh subfolder table are converted from their native until to
kWh.
Table 8. Subfolder energy fields -
Units in kWh
| Field |
Description |
| Energy in kWh |
Total Energy (consumed and produced) in the default reporting unit set for your
organization. |
| Energy PY in kWh |
Total Energy Previous Year. |
| Energy Rolling 12mth Avg in kWh |
Total Energy Rolling 12 months average. |
| Energy TD in kWh |
Total Energy To-Date - starting period is dynamic depending on visual filters. |
| Energy Variance in kWh |
Total Energy variance between current period and previous year is equal to
Energy - Energy PY. |
| Energy Variance % in kWh |
(Energy - Energy PY) / Energy PY * 100. |
| Normalized Energy in kWh |
Weather normalized energy. It is available when the regression model has been set up for the
relevant account or meter only. |
Native units
Table 9. Native unit
fields
| Field |
Description |
| Native Units |
Total Data = Actual Data + Accrued Data + Estimated
Data. |
| Native Units (Linked Meter) |
Total consumption data of linked meter of the account. |
| Native Units (Meter then Account) |
Returns linked meter’s total consumption data if it is available, otherwise return the
account’s total consumption data. |
| Native Units Normalized |
Weather normalized consumption data - available only when the regression model has been set
up for the relevant account or meter. |
| Native Units PY |
Native Units Previous Year. |
| Native Units Rolling 12mth Avg |
Native Units Rolling 12 months average. |
| Native Units TD |
Native Unites To-Date - starting period is dynamic depending on visual filters. |
| Native Units Variance |
Native Units variance between current period and previous year = Native
Units - Native Units PY. |
| Native Units Variance (Account vs Linked Meter) |
Total consumption data variance between the account and its linked meter. |
| Native Units Variance % |
(Native Units - Native Units PY) / Native Units PY *
100. |
| Native Units vs Normalized Variance |
Native Units - Native Units Normalized. |
| Native Units vs Normalized Variance % |
(Native Units - Native Units Normalized) / Native Units Normalized *
100. |
All values in the Native Units breakdown subfolder further breakdown the units
values into actual, estimated and accrued data
Table 10. Native units
breakdown fields
| Field |
Description |
| Accrued Data |
System generated accrued primary measure data. Only available if the Accrual feature is
turned on. |
| Accrued Data PY |
Accrued Data Previous Year. |
| Actual Data |
Actual primary measure data being captured in Envizi with Estimate flag set to No. |
| Actual Data PY |
Actual Data Previous Year. |
| Estimated Data |
Primary measure data captured in the system but being flagged as Estimate. |
| Estimated Data PY |
Estimated Data Previous Year. |
| Missing Data |
An approximation of the amount of data missing in an account. |
Others
Table 11. Others
| Field |
Description |
| Area |
Total Area of Data Types that are measured in area metrics, for example, m2. |
| Area PY |
Area Previous Year. |
| Area Variance |
Variance between current period and previous year : Area - Area
PY. |
| Area Variance % |
Variance % calculation: (Area - Area PY) / Area PY *
100. |
| Distance |
Total Distance of Data Types that are measured in distance metrics, for example, km. |
| Distance PY |
Distance Previous Year. |
| Distance Variance |
Variance between current period and previous year : Distance - Distance
PY. |
| Distance Variance % |
Variance % calculation : (Distance - Distance PY) / Distance PY *
100. |
| Mass |
Total Mass of Data Types that are measured in mass metrics , for example, tonnes. |
| Mass PY |
Mass Previous Year. |
| Mass Variance |
Variance between current period and previous year : Mass - Mass
PY. |
| Mass Variance % |
Variance % calculation : (Mass - Mass PY) / Mass PY *
100. |
| Volume |
Total Volume of Data Types that are measured in volume metrics, for example, kL. |
| Volume PY |
Volume Previous Year. |
| Volume Variance |
Variance between current period and previous year : Volume - Volume
PY. |
| Volume Variance % |
Variance % calculation : (Volume - Volume PY) / Volume PY *
100. |
Note: This Days of data table reports the of sum of the days of data for all records within the
reporting period..
Table 12. Subfolder Days of
data
| Field |
Description |
| Days Mismatch |
Number of days mismatching of expected number of days in the calendar month = Days in
Calendar Month - Days of Data Actual - Days of Data Estimated Accrued data is still being counted
as mismatching.
|
| Days of Data |
Total Days of Data = Actual + Accrued + Estimated. |
| Days of Data Accrued |
The number of days that data is accrued. |
| Days of Data Actual |
The number of days that data is actual. |
| Days of Data Estimated |
The number of days that data is estimated (actual data with Estimated flag set to
yes). |
| Days of Data Missing |
The number of days that data is missing. This field is only applicable for Account without
system automated Accrual function. |
Calendar
Table 13. Subfolder calendar
year
| Field |
Description |
Format example |
| Date |
Calendar Date. |
July 2023 |
| Date Short |
Calendar Date. |
Jul 23 |
| Month |
Calendar Month Number. |
7 |
| Month Long Text |
Calendar Month name. |
July |
| Month Name |
Calendar Month name short form. |
Jul |
| Month Short Text |
Calendar Month in short text format. |
Jul |
| Quarter |
Calendar Year quarter number. |
3 |
| Quarter Name |
Calendar Year Quarter Text. |
Q3 Jul-Sep 2023 |
| Quarter Name (Short) |
Calendar Year Quarter Number with Text. |
Q3 2023 |
| Quarter Text |
Calendar Year Quarter Number with Text. |
Q3 |
| Year |
Calendar Year. |
2023 |
| Year Short |
Calendar Year. |
23 |
Table 14. Subfolder financial
year
| Field |
Description |
Format example |
| FY |
Financial Year Range. |
22-23 |
| FY (Long) |
Financial Year. |
2023 |
| FY (Short) |
Financial Year. |
23 |
| FY Long Text |
Financial Year with Text. |
FY2023 |
| FY Quarter |
Financial Year Quarter Number. |
3 |
| FY Quarter Name |
Financial Year Quarter Text. |
Q3 Jul-Sep 2023 |
| FY Quarter Name (Short) |
Financial Year Quarter Text. |
Q3 2023 |
| FY Quarter Text |
Financial Year Quarter Number with Text. |
Q3 |
| FY Short Text |
Financial Year with Text. |
FY23 |
| FY Years Long |
Financial Year Range Long Format. |
2022-2023 |
Currency
Table 15. Currency
| Field |
Description |
| Currency Code |
ISO currency code, for example, AUD.
List of currency codes are sourced from the country info of Locations that have been set up in
the system.
|
| Currency Name |
ISO currency name, for example, Australian Dollar |
Group
Table 16. Group
| Field |
Description |
| Group Type |
Classification, Portfolio, Facility. |
| Level 1 Group |
Level 1 Group names. |
| Level 2 Group |
Level 2 Group names. |
| Level 3 Group |
Level 3 Group names. |
In general, Group Type = ‘Classification’ should always be applied as an All Pages Filter in
Power BI Reports to avoid data over-reporting.
Item
Table 17. Item
| Field |
Description |
| Account Style Category |
GHG Scope 3 category of the Account Style. |
| Account Style/Component |
Account Style name (for account) or Meter component name (for meter). |
| Accrue Type |
Accrue type of the account style, for example, Contiguous, Event. |
| Item Name |
Account Number (for account) or Serial No. (for meter). |
| Item Type |
Account or Meter. |
| Last Day Of Data |
The last day when the account or meter has data, for example, 21/09/2021. |
| Opened On |
Opened On date of the account or meter. |
| Period of Last Data |
An assessment of the last day of data and categorize it into different period bucket:
- Within last 4 months
- Within last 5 to 12 months
- Within last 13 to 24 months
- More than 24 months old
- From next month and onwards
- No Data
|
| Reference |
Account Reference (for account) or Meter Name (for meter). |
| Replaced On |
Replaced On (Closed On) date for the account or meter. |
| Source |
Reader field (for account) or Service Point’s ‘Service Provider’ field (for meter). |
| Supplier |
Supplier field (for account) or Service Point’s Supplier field (for meter). |
Table 18. Item Subfolder
-Attributes
| Field |
Description |
| Attribute 1 |
Custom attribute 1 of account (text). |
| Attribute 2 |
Custom attribute 2 of account (text). |
| Attribute 3 |
Custom attribute 3 of account (text). |
| Attribute 4 |
Custom attribute 4 of account (text). |
| Attribute 5 |
Custom attribute 5 of account (text). |
Table 19. Item sub folder - Scope
3
| Field |
Description |
| Calculation Method |
The Calculation Method used for the Account Style, used to determine Data Quality. |
| Data Quality |
The Data Quality is Envizi's Rating of the Calculation Accuracy based on the Calculation
Method used (from 1-5 where 1 is the best and 5 is the worst). |
Location
Table 20. Location
| Field |
Description |
| Associate Name |
Name of your organization. |
| Closed On |
‘Closed On’ attribute of Location, in yyyy/mm/dd format. |
| Latitude |
Latitude in decimals, for example, -34.3497 (attribute in sub folder ‘Coordinates’). |
| Longitude |
Longitude in decimals, for example, 135.8543 (attribute in sub folder ‘Coordinates’). |
| Has Gaps |
|
| Location ID |
‘ID’ field of Location. |
| Opened On |
‘Opened On’ attribute of Location, in yyyy/mm/dd format. |
| Location Name |
|
| Location Notes |
‘Notes’ text field of Location. |
| Location Ref |
‘Ref’ field of Location. |
| Location Type |
Office, Retail, Others and so on. |
| Reference |
‘Ref No’ field of Location. |
| Weather Station Name |
|
Table 21. Location sub folder -
Attributes
| Field |
Description |
| Attribute 1 |
Custom attribute 1 of location (text). |
| Attribute 2 |
Custom attribute 2 of location (text). |
| Attribute 3 |
Custom attribute 3 of location (text). |
| Attribute 4 |
Custom attribute 4 of location (text). |
| Attribute 5 |
Custom attribute 5 of location (text). |
| Attribute 6 |
Custom attribute 6 of location (text). |
| Attribute 7 |
Custom attribute 7 of location (text). |
| Attribute 8 |
Custom attribute 8 of location (text). |
| Attribute 9 |
Custom attribute 9 of location (text). |
| Attribute 10 |
Custom attribute 10 of location (text). |
| Numeric Field 1 |
Numeric custom attribute 1 of location (numeric). |
| Numeric Field 2 |
Numeric custom attribute 2 of location (numeric). |
Table 22. Location sub folder -
Address
| Field |
Description |
| Address |
Field in the Address record. If multiple addresses existing for the same location, only the
first created address is populated here. |
| Address - City |
Field in the Address record. |
| Address - Country Region |
Field in the Address record. |
| Address - Post Code |
Field in the Address record. |
| Address - State |
Field in the Address record. |
| Addressee |
Field in the Address record. |
| Mailing Name |
Field in the Address record. |
| Address Type |
Field in the Address record. Possible values include Physical, Registered, Delivery. |
Measure
Table 23. Measure fields
| Field |
Description |
| Category Type |
Default or Custom |
| Data Type |
Data Type name, for example, Electricity [kWh] |
| Data Type Category |
Category of Data Types, for example, Electricity, Natural Gas, Stationary Fuels,
Waste |
| Scope |
Scope 1, Scope 2, Scope 3, KPI, Offsets and so on.. |
| Unit of Measure |
Unit of the primary measure of each Data Type, for example, kWh |
Region
Table 24. Region
| Field |
Description |
| Continent |
Continent of the Location. |
| Country |
Country of the Location. |
| Region Name |
Region of the Location. |
| State |
State of the Location, if applicable. |
Tag
Table 25. Tag
| Field |
Description |
| Tag |
Tag Name |
| Tag Type |
Tag Type Name |
Note:
- By default only ‘Consolidation’ Tag Type and ‘CO2e and Base Measure’ Tag are included in the
table.
- In general, Tag Type = ‘Consolidation’ should always be applied as an All Pages Filter in Power
BI Reports to avoid data over-reporting.
- Other Generic Tag Types and Tags need to be enabled via
, if
they are required in the Monthly Dataset
- Other Custom Tag Types and Tags need to be enabled via the
, if they
are required in the Monthly Dataset.
Unit
Table 26. Unit fields
| Field |
Description |
| Area Unit |
Organization’s global reporting unit for Area. The default is m2 if not set. |
| Distance Unit |
Organization’s global reporting unit for Distance. The default is km if not set. |
| Emissions Unit |
Organization’s global reporting unit for Emissions. The default is tonnes if not set. |
| Energy Unit |
Organization’s global reporting unit for Energy. The default is GJ if not set. |
| Global Currency Unit |
Organization’s global reporting unit for Currency. The default is USD if not set. |
| Mass Unit |
Organization’s global reporting unit for Mass. The default is tonnes if not set. |
| Volume Unit |
Organization’s global reporting unit for Volume. The default is Litres if not set. |