Sigma Online User Manual
Managing Gaps in Data
A gap in the data is defined as a single missing or series of consecutive missing interval meter readings from a periodic channel.
For example:
- A Periodic Channel which is recording data every half hour - If there are any half hour periods without a reading, then this would be deemed a gap
- A Periodic Channel which is recording data daily - If there are any days missing a reading, then this would be deemed a gap
Note, it is not limited to half-hourly only, if your data is received every 15 minutes, or 5 minutes, then the system will support this.
Data Gap Notifications
If data gaps are found for one of the strategies, then notifications will be raised that are visible in the Notification Tab.
If the strategy was configured to auto-fill all gaps, then the notification will still be raised, but marked as resolved, to provide visibility of what the system has done, providing a full audit. Where the strategy was configured not to auto-fill all gaps for you, then these can be manually resolved using the "Resolve" functionality available. Highlight the applicable Data Gap Notification(s) in the list. If you select notifications which include types other than gaps, then a prompt will be displayed to confirm which strategy type you want to work with as the options available are contextual to the type of data issue being worked. The graph at the top shows the periodic data for the channel linked to the notification selected. The red area shows where the Gap is. You can change the number of Weeks used as a basis for calculating the data to use when filling the gap, select all the Notification records it should apply to then click Update. This will update the period to use when calculating the averaged data to fill the gap. Tip Use the "Select All" toggle at the bottom of the notifications panel if you want to quickly select all notifications. If you want to see what the filled data will look like, click first. This will show you what the filled gap would look like for the Notification that has been selected in the list. The filled period is highlighted in green. The Resolve Notifications pop up appears: A Note can be optionally entered if required and will be stored against the Notification. The following confirmation popup will be displayed: Click OK This basic workflow allows you to capture information and update the status of the Notifications, as per your own business processes. This is expected to be used to help you keep track of any investigative and follow-up actions which are been taken as a result of the Data Monitoring Notifications. For example: Highlight the Notification(s) you would like to update. Notifications can be selected in bulk, even across different strategy types. The Status will default to In Progress and is not editable - the Resolve and Ignore features will update the status. If you want to update the Sub-status, select the required option from the drop down list. The default options are: Pending Resolution You can customise the options available for selection to suite your needs here by using the Database Object Setup activity. You can also create reports in Energy Intelligence to keep track of the Notifications and their status, filtered as required to show the information as per your needs. If you want to update the Note for the Notification(s), then Tick Update Note and enter the note in the text box. Click OK to Save. This will update the status of the Notification to "Ignored" and will also prevent the same notification (for the same period and Impact) from being raised by the system again. If you want to update the Note for the Notification(s), then Tick Update Note and enter the note in the text box. You can view the Channel / amend the interval reading Data associated to the notification, if required. Please note, this option is only available if a single Notification is selected. Highlight the Notification for which you would like to edit the underlying monitoring strategy configuration. Resolving Data Gaps
Actions - Data Gap
Update Period Average Setting
Preview
Fill
Cancel
Adding Notes to Notifications
Ignoring Notifications
Editing Items
Editing Monitoring Strategies
Exporting to Excel
@ Copyright TEAM - Energy Auditing Agency Limited Registered Number 1916768 Website: www.teamenergy.com Telephone: +44 (0)1908 690018