Mathematical

​
Syntax
Description
​ceil(x)ceil(x)ceil(x)
​
Returns the rounded integer greater or equal for each element in the variable x. The ceil function always rounds up to the nearest integer.
​round(x,n)round(x, n)round(x,n)
​
Returns the floating-point value rounded to the n digits after the decimal point for each element in the variable x. By default, n equals 2 in Ubidots.
​sin(x)sin(x)sin(x)
​
Returns the sine in radians of each element in the variable x.
​cos(x)cos(x)cos(x)
​
Returns the cosine in radians of each element in the variable x.
​tan(x)tan(x)tan(x)
​
Returns the tangent of each element in the variable x.
​arcsin(x)arcsin(x)arcsin(x)
​
Returns in radians the inverse sine of each element in the variable x.
​arccos(x)arccos(x)arccos(x)
​
Returns in radians the inverse sine of each element in the variable x.
​arctan(x)arctan(x)arctan(x)
​
Returns in radians the inverse tangent of each element in the variable x.
​arctan2(x,y)arctan2(x, y)arctan2(x,y)
​
Returns in radians the trigonometric inverse tangent using the input variables x and y as Cartesian coordinates. Note: It will only perform the operation between values with the same timestamp.
​sinh(x)sinh(x)sinh(x)
​
Returns the hyperbolic sine of each element in the variable x.
​cosh(x)cosh(x)cosh(x)
​
Returns the hyperbolic cosine of each element in the variable x.
​tanh(x)tanh(x)tanh(x)
​
Returns the hyperbolic tangent of each element in the variable x.
​arcsinh(x)arcsinh(x)arcsinh(x)
​
Returns in radians the inverse hyperbolic sine of each element in the variable x.
​arccosh(x)arccosh(x)arccosh(x)
​
Returns in radians the inverse hyperbolic cosine of each element in the variable x.
​arctanh(x)arctanh(x)arctanh(x)
​
Returns in radians the inverse hyperbolic tangent of each element in the variable x.
​exp(x)exp(x)exp(x)
​
Returns the exponential of each element in the variable x.
​log(x,base)log(x, base)log(x,base)
​
Returns the logarithm of each element in the variable x. By default, the base is the Euler's number.
​abs(x)abs(x)abs(x)
​
Returns the absolute value of each element in the variable x.
​sqrt(x)sqrt(x)sqrt(x)
​
Returns the square root value of each element in the variable x.
   xandyrepresent variables as time series or dots​

SYNTHETIC VARIABLES - Previous

Native expressions

Date range

Last modified 6mo ago

Copy link