You are here:

Functions

The Functions drop-down contains a list of higher-order operations that can be included in a query.

Abs

Returns the absolute value of the point.

For example, to return the absolute value of a point for a sample period, use Abs("point"). This is the same as using Value("point") except the result is always a positive number.

Exp

Sets the exponent used to raise the base of natural logarithms (e).

For example, since the value of e is roughly 2.71828, raising to the second power by using the term Exp(2) would yield the result 7.389.

Int

Evaluates a numeric expression and returns the integer portion only.

For example, Int(3.14159) returns the value of 3.

Log10

Specifies the numeric expression for which LOG10(value) returns the value of x in the equation 10^x = value.

For example, Log10(50) returns the result of 1.699. Or Log10(100) returns 2.

Log10-1

The inverse of Log10. This function takes the base of 10 and raises it to the value provided.

For example, Log10-1(2) returns a value of 100.

The inverse of Exp function. This is called the natural logarithm. It returns the exponent of the equation e^x = value.

For example, Ln(7.389) returns the value of 2. This is because e (2.71828) raised to the second power is equal to 7.389.

Sqrt

Returns the square root of the value provided.

For example, Sqrt(100) returns a value of 10.

Hours

Returns the number of hours an expression is TRUE. The Hours operator uses the Value operator, which returns the value of a point at each sample time. The Hours function is a rollup function that shows one value calculated for the specified range. For more information about the Value operator, see Value.

Examples:

Hours(Value(“AC2-SF-A”)>2)

Hours(Value(“AC2-SF-S”)=1)

Hours(Value("OCC")=1 AND Value("AC2-SF-S")=1)

Cycles

Cycles returns the number of times the expression has cycled from FALSE to TRUE. The Cycles operator uses the Value operator, which returns the value of a point at each sample time. The Cycles function is a rollup function that shows one value calculated for the specified range.For more information about the Value operator, see Value.

For example, Cycles(Value("AC2-GV1")=1)

More details