AVERAGE Examples
- Last UpdatedAug 17, 2022
- 1 minute read
Example 1
The following expression returns the average flow rate of a pump.
AVERAGE( Pump101.Flow )
Example 2
The following expression returns the average flow rate of a pump over 10 minute intervals.
AVERAGE( Pump101.Flow, 10 Minute )
Example 3
The following expression returns the average minute value of the time over 5 minute intervals.
AVERAGE( SysTimeMin, 5 minute )
Represented as a query:
SELECT DateTime, Value, OPCQuality
FROM History
WHERE wwExpression = 'AVERAGE( SysTimeMin, 5 minute )'
Results:
|
DateTime |
Value |
OPCQuality |
|
2022-03-31 12:00:00.0000000 |
2 |
192 |
|
2022-03-31 12:05:00.0000000 |
7 |
192 |
|
2022-03-31 12:10:00.0000000 |
12 |
192 |
|
2022-03-31 12:15:00.0000000 |
17 |
192 |
|
... |
... |
... |