(v24) Arithmetic Functions

Arithmetic Functions

This applies to: Visual Data Discovery

Custom metrics support the following arithmetic functions in your aggregate functions.

The following table describes the supported arithmetic functions.

Function	Type	Description
POWER(numeric1, numeric2)	numeric	Returns numeric1 raised to the power of numeric2.
MOD(numeric1, numeric2)	numeric	Returns the remainder (modulus) of numeric1 divided by numeric2. The result is negative only if numeric1 is negative.
SQRT(numeric)	numeric	Returns the square root of numeric.
LN(numeric)	numeric	Returns the natural logarithm (base e) of numeric.
LOG10(numeric)	numeric	Returns the base 10 logarithm of numeric.
EXP(numeric)	numeric	Returns e raised to the power of numeric.
CEIL(numeric)	numeric	Rounds numeric up, returning the smallest integer that is greater than or equal to numeric.
FLOOR(numeric)	numeric	Rounds numeric down, returning the largest integer that is less than or equal to numeric.
ROUND(numeric1, numeric2)	numeric	Rounds numeric1 to optionally numeric2 (if not specified 0) places right to the decimal point.
RAND(seed)	numeric	Generates a random double between 0 and 1 inclusive, optionally initializing the random number generator with seed.
SIGN(numeric)	numeric	Returns the signum of numeric.
SIN(numeric)	numeric	Returns the sine of numeric.
COS(numeric)	numeric	Returns the cosine of numeric.
TAN(numeric)	numeric	Returns the tangent of numeric.
COT(numeric)	numeric	Returns the cotangent of numeric.
ASIN(numeric)	numeric	Returns the arcsine of numeric.
ACOS(numeric)	numeric	Returns the arc cosine of numeric.
ATAN(numeric)	numeric	Returns the arctangent of numeric.
PI()	numeric	Returns a value that is closer than any other value to pi.
DEGREES(numeric)	numeric	Converts numeric from radians to degrees.
RADIANS(numeric) >	numeric	Converts numeric from degrees to radians.