Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overdue data is defined as interval meter reading data that is now deemed as missing as it has not been received from the date it was last expected. It also highlights where no data at all has been received.

...

  • a periodic channel which is recording data for every interval on a daily basis. If the data is not received for the day before last, then this would be deemed overdue.
  • a periodic channel which is recording data for every interval on a monthly basis. If the data is not received for the previous month at the start of the next month, then this would be deemed overdue.

...

Creating an Overdue Data Strategy

Insert excerpt
Managing Creating a Gaps in Data StrategyManaging
Creating a Gaps in Data Strategy
nameCreating a Monitoring Strategy
nopaneltrue


Overdue Data Configuration

The Monitoring Strategy Editor also contains an Overdue Data Configuration section that allows you to set the specific configuration to use when finding and managing the overdue data.

Image Modified

FieldDefaultDescription
Data Load FrequencyDaily

Specification of the frequency at which data is loaded to the channel. Choose from:

  • Daily
  • Monthly
Offset (Days)1

Choose the offset between the end date of the missing data period being checked based on the current date.

Examples

  • Data should be received daily and I want to know if I have not received data after 2 days:
    • Data Load Frequency should be set to "Daily"
    • Offset should be set to "2"

Here, if data had been received up to and including 21/07/2019, the data would be deemed overdue from the 24/07/2019

  • Data should be received monthly, and I want to know if I have not received data 5 days after the end of the previous month:
    • Data Load Frequency should be set to "Monthly"
    • Offset should be set to "4"

Here, if data had been received up to and including 30/06/2019, the data would be deemed overdue from the 05/08/2019.

Also includeAll unchecked

Define the combination of data values that should be considered missing data.

Options include:

  • Zero - No Error
    • Checks for recorded values of '0' AND a status of 'No Error'. This represents data that the source metering system has sent as an actual meter reading value of zero. This should be used with caution as could represent valid data - it is intended to check meters which never expect to receive readings with a value of zero based on their operation.
Auto Fill DataOff

An on/off toggle to determine whether the system should automatically estimate the data that is deemed to be overdue, based on an average from a historical period (specified below).

Auto Fill - Weeks to Average4

Specify the number of weeks that should be used as a basis when calculating the data to use for automatically extrapolating historical data.

More information about how this feeds into the system processing that it supports when filling the data can be seen here.


  • Click OK to save the Monitoring Strategy

...



Info

Once the Strategy has been set up, Sigma will review the data each night and create any relevant notifications in the Notifications tab

Overdue Data Notifications

If overdue data is found for one of the strategies, then notifications will be raised that are visible in the Notification Tab.

Where the strategy was configured to auto-fill (estimate) overdue data for you, then the notification will still be raised in a closed state, for you be able to view what the system has done, providing a full audit.

...

Excerpt

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 Overdue Data Notification(s) in the list.

Click  Image Removedto open the Resolve Notifications popup

Info

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.

Image Removed

The Resolve Notifications popup will be displayed, showing a list of the Notifications being resolved.

Image Removed

The graph at the top shows the periodic data for the channel linked to the notification selected. The red area shows the period of time for the missing overdue data.

Drag the mouse around the area on the graph to zoom in.

Click Image Removed to reset.

Actions - Overdue Data

Update Period Average Setting

You can change the number of Weeks used as a basis for calculating the data to use when filling the overdue period. 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
titleTip

Use the "Select All" toggle at the bottom of the notifications panel if you want to quickly select all notifications.

Image Removed -

Preview

If you want to see what the estimated data will look like, click Image Removed first. 

This will show you what the resolution would look like for the Notification that has been selected in the list. The extrapolated period is highlighted in green.

Image Removed

Drag the mouse around the area to zoom in

Image Removed

Click Image Removed to reset

Fill

Click Image Removedto add the data.

The Resolve Notifications pop up appears:

Image Removed

A Note can be optionally entered, if required and will be stored against the Notification.

Click OK.

The following confirmation popup will be displayed: 

Image Removed

Click OK.

Cancel

Click Image Removed to cancel without making any changes. You will be returned to the list of all Notifications.