Count number of times a particular value occurred. Leave the value blank to count missing value.



Input Data*

Defines the time series data fed into the function. This can be a sensor ID or another function.


Time frame or length of time


sensor value (i.e. value, pressure, flow rate)


=, >, <, <=, >=

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.

*Input data is optional in most cases. If Info360 detects that the first input is time series data, it will be applied to the function. Otherwise, the current active sensor's data will be used, which is often the case in Reference Charts.

Example Usage as an Expression:

CountValue(24, 0, ‘>’) - Counts the number of hours during the past day (if using hourly timesteps) that the sensor measured a positive value.

CountValue(100,'',‘=’) - Counts the intervals that the sensor has no recorded values, or "null" values, within the last 100 intervals.

Example Reference Chart:

The following example shows a pump status feed, and a calculation of the total hours that the pump has been on over the past day. In this example, the TimeSpent function is replicated using the CountValue function (divided by 4 to get hours from 15 minute data).

The CountValue output line becomes flat at some low points because the 24 hour interval is exactly spanning an off cycle; so as an old hour is removed from the total, a new hour is being added.

For information on setting up custom equations and syntax, please refer to Analytical Functions.