Counts the number of times a particular value occurred. Leave the value blank to count a missing value.
Syntax
countvalue(TimeSeries, Period, Value, Operator)
| Parameter | Description |
|---|---|
|
TimeSeries |
This can be a node with time series data or another function. |
|
Period |
Time frame or length of time |
|
Value |
Sensor value (i.e. value, pressure, flow rate) |
|
Operator |
=, >, <, <=, >= Note: These must be inserted inside single quotes: '=', '>', etc.
|
|
Count All |
A value of 1 or null will count all instances within the past period. Otherwise, the count will reset whenever a series is broken. |
Example expressions
countvalue(@node, 24, 15, '>'): Counts the number of hours during the past day (if using hourly time steps) that the sensor measured a value greater than 15.
countvalue(@node, 100,'','='): Counts the intervals that the sensor has no recorded values, or "null" values, within the last 100 intervals.
Example chart:
The chart below demonstrates the following expression: countvalue(@FA_level, 24, 15, '<')
It counts the number of times the level sensor dropped below 15 using a 24-hour moving window and an hourly interval.
In this example the TimeSpent function is also shown with an hourly interval set.
