The Data Quality section allows users to easily identify any errors or mistakes that might negatively affect the quality of data entered from spreadsheets in the Accounts section. These errors can also be identified to some degree in the Accounts tab, but the Data Quality section is designed specifically for this purpose. At the Global level, all sites are listed with accounts organized by types: Energy, Water, and Site. You can see a site's accounts within a category by selecting the corresponding button for each site.
Note: Currently, rules cannot be set for emissions, transportation, waste, or weather, so these Types do not appear in the Data Quality tab.
The color of the icons in these buttons indicates whether or not there is an error present in at least one of the accounts associated with each category. Red indicates that there is an error, while blue indicates there are no errors.
All accounts and analytics within the selected category will appear after clicking on the button. In the right column, you can easily see if an account or analytics set has any errors within its data by checking for a "Fail" message. If you would like to see more details about which data quality checks are failing, you can hover over the exclamation icon. For an explanation of these rules, see the Data Quality Rules Definitions page.
The buttons next to each account allow you to edit or view the data associated with it. An edit icon means you can open a spreadsheet to directly update data, while a view icon means the spreadsheet cannot be edited.
Selecting the edit button will open a data entry spreadsheet for an account. This is the same spreadsheet that can be accessed from the site's Accounts section, and any changes made to the data here will update the account for the site. When you open a spreadsheet with a data quality error, you may notice the error right away as a red-shaded cell, or you may need to use the dropdown to navigate to the highlighted entry.
If you hover over a red-shaded cell, a popup will appear with more information about the error or errors associated with that data. In the example shown below, it looks like the account has not been updated for more than 30 days.
To fix this, we will need to add an entry with a more recent date.
Once this has been updated, click save. If your updates have corrected the error, all cells will turn white and the Data Quality errors dropdown will disappear. After closing the modal, the account will receive a "Pass" message, and if all other accounts are clear of errors, the button for the Data Quality category will turn blue.
