Accounts incomplete data report
The Accounts Incomplete Data report provides details of accounts that contain missing or overlapping data across a reporting period.
Column | Description |
---|---|
Organization |
Organization name. |
Group |
Group name. Since an account can belong to multiple groups, this report includes the full group string, separated by a semi colon, as reference information. |
Location |
Location name. |
Account_Number |
Account number. |
Start_Period |
Start date for the period that the report was run for. |
End_Period |
End date for the period that the report was run for. |
Account_Ref |
Account reference |
Supplier |
Supplier of the utility or emission source. |
Reader |
Indicator of whether the data was manually captured or captured by a connector. |
Opened_On |
Date that the account was opened. |
Replaced_On |
Date that the account was closed, if applicable. |
Data_Type |
Type of data, for example, electricity, gas. |
Period_Starting |
The data is reported in monthly blocks. The starting period refers to the start date within each monthly block. |
Days_In_Month |
Number of days within that particular month. |
Expected_Days_In_Month |
The number of days that data is expected in the month. |
Days_Of_Data |
The number of days within that month that contain actual data. |
Units |
Quantity or consumption units. |
In |
Unit of measure. |
Daily_Rate |
Daily rate or the monthly block that is calculated by dividing by the units. |
Days_Mismatch |
The number of days missing in each monthly block for each account. This is calculated by
subtracting Days_Of_Data from Expected_Days_In_Month . |
Consolidation |
The percentage of the account that is included in enterprise reporting. |
Report behavior
For the report to be effective in identifying missing data, accounts must have an
Opened_On
date defined. Otherwise, when the report is run for a reporting period
that is dated earlier than the account has data for, it will report it as missing data. Similarly,
if an account has been closed and no Replaced_On
date has been set, then when the
report is run for a period extending past the Replaced_On
date, missing data will
be reported for the account.
Account data is not be included in the report unless the account contains some missing or mismatched account data for the selected reporting period.
The report also provides information on what data has been entered in the account if missing or overlapping data is reported for you to have some context for the data that has been captured in other months for that account.
The report only shows contiguous data. Gaps in contiguous data indicate that data is missing. This is because by definition the data should be continuous. In contrast, gaps in event data could relate to periods of non-consumption, rather than missing data.
- Contiguous data
- Relates to a continual data stream, for example, electricity data. In this case, one bill commences as the other ends. For example, 14-Jan-2011 to 13-Feb-2011 with the next bill from 14-Feb-2011 to 13-Mar-2011.
- Event data
- Relates to sporadic data points, for example, fuel or flight data. In this case, data is recorded as discrete consumption points. For example, flights were taken on 5-Jan- 2011 and 7-Jan-2011 and then no flights until 15-Apr-2011. This is not missing data
Finding data mismatches
- Run the report. In global search, select Report, and enter Accounts Incomplete Data report.
- Select the report from the Reports grid to open it.
- Define the report criteria.
- Download the report as a CSV file.
- Apply a filter on the header row.
- Filter the report to remove any 0 values in Days_Mismatch. The report updates to show records that have a value in Column T - Days_Mismatch only.
- Review the records that are identified as having missing data or mismatched account data.
- Positive Days_Mismatch
- There is missing account data in the period.
- Negative Days_Mismatch
- There are overlapping periods in your account data. For example, a value of
-1
indicates that the last day of one period overlaps with the first day of another period.
Resolving mismatched data
Navigate to the mismatched accounts and follow the data capture process to fill in any missing data and to correct any periods of data that overlap. For more information, see Capturing data records manually.