AVERAGE examples
- Last UpdatedFeb 07, 2025
- 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 flow rate of all streams that include ".Flow" in their tag name at 10 minute intervals.
AVERAGE(SELECT("TagName",".Flow"), 10 Minute)
Example 4
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 |
|
... |
... |
... |