Monthly Dataset - Glossary - Basic Fields
The Monthly Dataset PowerReport allows you to build your own Power Report by utilizing predefined data fields.
This page lists all basic fields in the Monthly Dataset and their definitions. For other fields not listed on this page, such as Custom Measures, Targets, Programs, Loction-Group Cross Filtering and Weather releated fields, please refer to the Monthly Dataset Glossary - Advanced Fields page.
Cost
Field | Description |
---|---|
Accrued Cost | System generated accrued cost (only available if the Accrual feature is turned on) |
Accrued Cost PY | Accrued Cost Previous Year |
Actual Cost | Actual cost being captured in the platform (with Estimate flag set to No) |
Actual Cost PY | Actual Cost Previous Year |
Cost | Total Cost - sum of Actual Cost, Accrued Cost and Estimated Cost |
Cost PY | Total Cost Previous Year |
Cost Rolling 12mth Avg | Total Cost rolling 12 months average |
Cost TD | Total Cost To-Date - starting period is dynamic depending on visual filters |
Cost Variance | Total Cost Variance between current period and previous year = Cost - Cost PY |
Cost Variance % | (Cost - Cost PY) / Cost PY * 100 |
Estimated Cost | Cost captured in the system but being flagged as Estimate |
Estimated Cost PY | Estimated Cost Previous Year |
Unit in Global Currency (sub folder of Cost)
All cost values in this table are converted to the global currency unit as defined for your organization
Field | Description |
---|---|
Accrued Cost Global | System generated accrued cost (only available if the Accrual feature is turned on) |
Accrued Cost PY Global | Accrued Cost Previous Year |
Actual Cost Global | Actual cost being captured in the platform (with Estimate flag set to No) |
Actual Cost PY Global | Actual Cost Previous Year |
Cost Global | Total Cost - sum of Actual Cost, Accrued Cost and Estimated Cost |
Cost PY Global | Total Cost Previous Year |
Cost Rolling 12mth Avg Global | Total Cost rolling 12 months average |
Cost TD Global | Total Cost To-Date - starting period is dynamic depending on visual filters |
Cost Variance Global | Total Cost Variance between current period and previous year = Cost - Cost PY |
Cost Variance % Global | (Cost - Cost PY) / Cost PY * 100 |
Estimated Cost Global | Cost captured in the system but being flagged as Estimate |
Estimated Cost PY Global | Estimated Cost Previous Year |
Emissions
Field | Description |
---|---|
CH4 Emissions | CH4 gas emissions in its equivalent CO2 amount |
CH4 Emissions PY | CH4 Emissions Previous Year |
CO2 Emissions | |
CO2 Emissions PY | CO2 Emissions Previous Year |
Emission Variance | Total GHG Emissions variance between current period and previous year = Emissions - Emissions PY |
Emission Variance % | (Emissions - Emissions PY) / Emissions PY * 100 |
Emissions | Total GHG Emissions = CH4 Emissions + CO2 Emissions + N2O Emissions |
Emissions PY | Total GHG Emissions Previous Year |
Emissions Rolling 12mth Avg | Total GHG Emissions Rolling 12 month average |
Emissions TD | Total Emissions To-Date - starting period is dynamic depending on visual filters |
Indirect Emissions | Indirect emissions such as Scope 3 upstream or downstream emissions which is associated with the same Scope 1 or Scope 2 activity data. |
Indirect Emissions PY | Indirect Emissions Previous Year |
Lifecycle Emissions | Total Lifecycle Emissions = Emissions + Indirect Emissions |
Lifecycle Emissions PY | Total Lifecycle Emissions Previous Year |
Market-based Emissions | Market-based Emissions of Electricity - available only when the Market-based reporting methodology has been set up in the platform |
Market-based Emissions PY | Market-based Emissions Previous Year |
N2O Emissions | N2O gas emissions in its equivalent CO2e amount |
N2O Emissions PY | N2O Emissions previous year |
Normalized Emissions | Weather normalized emissions - available only when the regression model has been set up for the relevant account or meter |
Energy
Field | Description |
---|---|
Energy | Total Energy (consumed and produced) in the default reporting unit set for your organization |
Energy PY | Total Energy Previous Year |
Energy Rolling 12mth Avg | Total Energy Rolling 12 months average |
Energy TD | Total Energy To-Date - starting period is dynamic depending on visual filters |
Energy Variance | Total Energy variance between current period and previous year = Energy - Energy PY |
Energy Variance % | (Energy - Energy PY) / Energy PY * 100 |
Normalized Energy | Weather normalized energy - available only when the regression model has been set up for the relevant account or meter |
Energy - Unit in kWh (sub folder of Energy)
All energy values in this sub folder are converted to 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 = Energy - Energy PY |
Energy Variance % in kWh | (Energy - Energy PY) / Energy PY * 100 |
Normalized Energy in kWh | Weather normalized energy - available only when the regression model has been set up for the relevant account or meter |
Native Units
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 the platform (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 |
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 |
Others
Field | Description |
---|---|
Area | Total Area of Data Types that are measured in area metrics (e.g., m2) |
Area PY | Area Previous Year |
Distance | Total Distance of Data Types that are measured in distance metrics (e.g., km) |
Distance PY | Distance Previous Year |
Mass | Total Mass of Data Types that are measured in mass metrics (e.g., tonnes) |
Mass PY | Mass Previous Year |
Volume | Total Volume of Data Types that are measured in volume metrics (e.g., kL) |
Volume PY | Volume Previous Year |
Days of Data (sub folder of Others)
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. |
Ratios (column based)
A ratio is the result of mathematical division between two Data Type Groups
Ratios are predefined custom measures specifically for your organization
Ratios can be defined by System Administrators of the platform
Once defined, each measure will be available as a separate column in this table
Calendar
Field | Description |
---|---|
Date | Calendar month date, e.g., July 2021. Can be used as a monthly filter |
Day | Day of the month in the value range of 1 to 31 |
Day of Week | Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday |
FY | Financial Year, e.g., 21-22 |
FY Quarter | Financial Year Quarter in the value range of 1 to 4 |
FY Quarter Name | Full name of the FY quarter, e.g., Q1 Jul-Sep 21-22 |
Month | Month in the value range of 1 to 12 |
Month Name | Month name short form, e.g., Jan, Feb, Mar |
Quarter | Calendar year quarter in the value ranges of 1 to 4 |
Quarter Name | Full name of the calendar year quarter, e.g., Q3 Jul-Sep 2021 |
Year | Calendar Year, e.g., 2021 |
Currency
Field | Description |
---|---|
Currency Code | ISO currency code, e.g., 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, e.g., Australian Dollar |
Data Type Group (row based)
Field | Description |
---|---|
Data Type Group Amount | Total data by aggregating all Data Types in the Data Type Group |
Data Type Group Amount PY | Data Type Group Amount Previous Year |
Data Type Group Name | Name of the Data Type Group (predefined, customizable) |
Data Type Group Unit | Reporting unit of the Data Type Group (predefined, customizable) |
Data Type Groups (column based)
Data Type Groups are predefined aggregated list of data types for your organization
Data Type Groups can be defined by System Administrators of the platform
Once defined, each Data Type Group will be available as a separate column in this table
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 overreporting
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, e.g., 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, e.g., 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:
|
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) |
(Account) Attributes (Sub-folder of Item)
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) |
Account Style Category
Field | Description |
---|---|
Category | The Scope 3 Category Number (From 1-15) |
Category Name | The Scope 3 Category Name as it appears in the Scope 3 Guidance |
Scope | Scope 1, Scope 2, Scope 3, KPI, Offsets etc. |
Scope 3 Stream | Classification of the Category (Upstream or Downstream) |
Item - 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
Field | Description |
---|---|
Associate Name | Name of your organization |
Closed On | ‘Closed On’ attribute of Location, in yyyy/mm/dd format |
Latitude | Latitude in decimals, e.g., -34.3497 (attribute in sub folder ‘Corordinates’) |
Longitude | Longitude in decimals, e.g., 135.8543 (attribute in sub folder ‘Corordinates’) |
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 etc. |
Reference | ‘Ref No’ field of Location |
Weather Station Name |
(Location) Attributes (Sub-folder of Location)
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) |
(Location) Address (Sub-folder of Location)
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 | same as above |
Address - Country Regioin | same as above |
Address - Post Code | same as above |
Address - State | same as above |
Addressee | same as above |
Mailing Name | same as above |
Address Type | same as above - possible values: Physical, Registered, Delivery etc. |
Measure
Field | Description |
---|---|
Category Type | Default or Custom |
Data Type | Data Type name, e.g., Electricity [kWh] |
Data Type Category | Category of Data Types, e.g., Electricity, Natural Gas, Stationary Fuels, Waste |
Scope | Scope 1, Scope 2, Scope 3, KPI, Offsets etc. |
Unit of Measure | Unit of the primary measure of each Data Type, e.g., kWh |
Ratio (row based)
Field | Description |
---|---|
Ratio Amount | Calculated ratio amount based on ratio definition - numerator Data Type Groups divided by denominator Data Type Groups |
Ratio Amount PY | Ratio Amount Previous Year |
Ratio Denominator | Total reporting amount of Data Type Groups that is being defined as ratio denominator |
Ratio Denominator PY | Ratio Denominator Previous Year |
Ratio Name | Name of the Ratio (predefined, customizable) |
Ratio Numerator | Total reporting amount of Data Type Groups that is being defined as ratio numerator |
Ratio Numerator PY | Ratio Numerator Previous Year |
Ratio Optional Unit | Optional Unit of the Ratio (predefined, customizable) |
Ratio Period Name | Optional Ratio attribute defined for ratio accumulative calculation if required
|
Scale_By | Scale by number (predefined, customizable) e.g., 100 is typically used for scaling up percentage values |
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
Field | Description |
---|---|
Tag | Tag Name |
Tag Type | Tag Type Name |
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 overreporting
Other Generic Tag Types/Tags need to be enabled via Admin → Organization Preferences → Reporting and Dashboard Preferences if they are required in the Monthly Dataset
Other Custom Tag Types/Tags need to be enabled via the Admin → Custom Tags if they are required in the Monthly Dataset
Unit
Field | Description |
---|---|
Area Unit | Organization’s global reporting unit for Area (default is m2 if not set) |
Distance Unit | Organization’s global reporting unit for Distance (default is km if not set) |
Emissions Unit | Organization’s global reporting unit for Emissions (default is tonnes if not set) |
Energy Unit | Organization’s global reporting unit for Energy (default is GJ if not set) |
Global Currency Unit | Organization’s global reporting unit for Currency (default is USD if not set) |
Mass Unit | Organization’s global reporting unit for Mass (default is tonnes if not set) |
Volume Unit | Organization’s global reporting unit for Volume (default is Litres if not set) |
Other Notes
All values in the Monthly Dataset is after applying both Consolidation Rules an Location-Group Membership % if they have been set up in 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 Admin → Organization Preferences → Reporting and Dashboard Preferences (change of the settings are available to System Administrator users only)