For each sample interval, the following five summary values are stored in the SCADAWatch database.
The first value in each time interval is used to create the data series
The highest value in each time window is used
The lowest value in each time window is used
The final value in each time window is used
The average value recorded in each time window is used
SCADAWatch builds sampled data tables for each sensor down to the specified minimum interval set for each sensor (e.g. 5 minutes - see Interval Setting in Server Configuration). The example tables below illustrate this process. The Open, High, Low, Close, and Average values are stored at the end of each sample interval, for each time resolution (e.g. hourly, daily, etc.). For example, the data between 0:00 - 0:05 are sampled and summarized at time 0:05.
Be sure to understand which sample value you are using. Simply opening a Chart from the map will use the default series type (set in the Settings page) which is initially set as Close. In many cases, the default series type may not be appropriate for the analysis you'd like to do. For example, using hourly Close values to calculate the volume from a pump station will miss variations in data and likely be inaccurate.
Graphically, a summary of the sample values can be easily seen in SCADAWatch using Candlestick or OHLC ChartsCharts in Historical Chart Configuration. These charts use vertical lines at each time step which extend from the Low to the High, with markers at the Open and Close values. The candlestick chart below shows the open and close values using the top and bottom of the thicker portion of the candlestick. When the open is less than the close (e.g. tank is filling), the candlestick is blue, while if the reverse is true (e.g. tank is draining) the candlestick is orange.
Often, SCADA data can be prone to noise and gaps in data. SCADAWatch allows for thresholds and value mapping to be configured for each sensor individually. Refer to the Sensor Configuration page and the Sampling Logic tree for more information.