The Anomalies feature allows users to run anomaly tests on their organisations data to identify data items which do not conform to an expected pattern of the dataset. For example data entries that are considerably different from the remainder of the data. The anomaly tests can be applied to individual activities and scheduled to run daily, weekly, monthly, yearly, bi-weekly, bi-monthly, quarterly, or four-weekly.
There are 3 anomaly tests available to run for Non - Intervals data:
- Duplicate Entries - There are at least two rows of data within an activity/meter that share the same dates and quantity.
- Data Overlap between 2 Entries - Raises an anomaly if there are two pieces of data within an activity/meter have start and end dates that overlap each other.
- Compare Quantity to Same Period Previous Year - Compares the input quantity from one period to the same period in the previous year for an activity/meter, and raises an anomaly if the % increase or decrease is over the tolerance set
To set up mass Anomaly settings across Non Interval Data (non half hourly) activities and meter follow the steps below.
Step 1: To begin, navigate to the GHG Activities screen by selecting the Data Management menu icon at the top of the screen and clicking on GHG activities from the drop down. Once on the GHG Activities screen click on the "Settings" button above the chart as shown below. Bulk Activity Settings button is available on the GHG Activities screen, Meters Screen, Transport screen and EED:A8 Screen. Users can go to any of these screens to use the Bulk Settings feature. For this example the GHG activities screen is used.
Step 2: Once the Settings button is clicked a box will appear asking do you want to configure:
A - Data Completeness
B - Anomaly Testing
C - Email Reminders and Alerts
Select B to configure Anomaly testing settings for Non Interval Data meters.
Step 3: On the next screen click on the > symbol beside (B) Non Interval Data - Anomalies to set up Non Interval Data testing.
Step 4: Next tick the box (A) to enable Interval Anomaly settings for activities, once the box is ticked a screen will appear to allow the user to set specific settings.
Step 5: On this screen users select the settings they wish to apply to their activities for interval data anomaly testing. Place a tick beside the tests you wish to enable (C). Users can then set a tolerance (B) for certain tests, the tolerance is currently defaulting to 25%. Users can change this by inputting their own tolerance figure. Once the settings for Anomaly testing are set up, click Continue.
The user must also set up period for scanning by answering the questions:
Choose a period for anomaly testing - , here you can set the anomaly scanning to scan daily data, weekly data, monthly data, yearly data, bi-weekly data, bi-monthly data, quarterly data, or four-weekly data. For example Compare Quantity to Same Period Previous Year test, if you choose monthly it it will compare monthly data to the same period previous year.
After a scan runs, the number of days before it should run again to check the issue(s) have been resolved should be input here. For example give the user 7 days to correct the totals before running the scan again.
Date of first scan.
If you wish to scan historic data also click yes, once this selected you will then be asked to select a start date to scan historic data.
Once the settings for Anomaly testing are set up, click Continue.
Step 6: On this screen users will select the activities they wish to apply the non-interval data anomalies settings to. There is an activity table that shows all activities in the system if you wish to apply settings to all activities click continue. If you wish to filter this list use the three filters at the top A (company), B (All Activity Types) and C (All Countries) to determine what activities you wish to mass apply the data anomalies settings to.
A - Company: By org structure for example apply data anomalies settings to all activities assigned to a certain building
B - By activity types: select a specific activity type for example Air Transport and apply these settings to all air transport activities in the system.
C - All Countries: for example select United Kingdom and apply settings to all UK activities.
These filters can be used together to determine what activities the user wishes to apply settings to. For example select Activity Type: Purchased Used and Electricity and Country type France to apply settings to all
electricity activities in France. Click Finish when you have selected the activities you wish to mass apply the data anomalies settings to.
Step 7: The non-interval data anomaly settings for the selected activities are now setup, once the system has completed a background users will receive an email of completion. Click close to finish the process.