You can use the Data Anomalies analysis section to check for and correct duplicate data and date overlaps, and compare the input quantity from one period to the same period in the previous year. You can filter results in both the chart and table using the Organisation or Geographic navigation tree, Data Filters, or table column filters.

  1. In Diligent ESG, select Analysis and select Data Anomalies.
  2. In the Organisation or Geographic navigation tree, select a company, business, or location to filter the tests shown in the table.
  3. In the Data Filters section, expand Scope, Source Category, and Activity Type, and select or clear the checkboxes to filter the tests shown in the table.
  4. In the data table section, in the fields below the column headings, enter a term or figure to filter the test results shown, such as a percentage in the Variance % column.
  5. In the Type of test dropdown, select Duplicate entries, Data overlap, or Compare with same period last year to filter the results shown. Select All to view all test types.
  6. (Optional) At the top of the data table section, select the Export to Excel icon or Export to CSV icon to export the table.
  7. Select the Select Columns dropdown, select the checkboxes beside other columns that you want to add, and select Show/Hide.
  8. Select Ignore to ignore an anomaly.
  9. In a test entry row, select the Anomaly ID number to view a test and its results in more detail.
  10. In the test details page, manage an anomaly record using one of the following options:
    • Select the Delete icon  to delete the appropriate data entry in the table
    • Select an Entry ID number and edit the entries to their correct values
    • Select Ignore to ignore an anomaly
  11. (Optional) Select View ignored anomalies or Return to current anomalies to switch between current and ignored anomaly tables.
  12. (Optional) Select the Tests tab to view the status and progress of all the data anomaly tests. Select Results to return to the details of all the data anomaly tests.