min(expression, expression) |
Returns the smallest value of two expressions. |
min([metric1], [metric2]) |
max(expression, expression) |
Returns the largest value of two expressions. |
max([metric1], [metric2]) |
sin(expression) |
Returns the sine of a metric or expression. Used in Trigonometry. |
sin([metric1]) |
cos(expression) |
Returns the cosine of a metric or expression. Used in Trigonometry.
|
cos([metric1]) |
tan(expression) |
Returns the tangent of a metric or expression. Used in Trigonometry. |
tan([metric1]) |
abs(expression) |
Returns the absolute value of a metric or expression. Use to convert negative numbers to positive numbers. |
abs([metric1]) |
sqrt(expression) |
Returns the square root of a metric or expression. |
sqrt([metric1])
|
round(expression) |
Rounds a numeric value to the nearest whole number. The mid-point is rounded up. Examples:
- round(10.2) rounds down to 10
- round(10.5) rounds up to 11
- round(10.7) rounds up to 11
|
round([metric1]) |
round(expression, digits) |
Rounds a numeric value to a specified number of digits. Positive digits round to the specified number of decimal places. Negative digits round to the nearest multiple of 10. Examples:
- round(2.15, 1) rounds up to 2.2
- round(70, -2) rounds up to 100
|
round([metric1], 1) |
floor(expression) |
Returns a numeric value rounded down towards zero. Examples:
- floor(10.2) rounds down to 10
- floor(10.5) rounds down to 10
- floor(10.7) rounds down to 10
|
floor([metric1], 2) |
floor(expression, expression) |
Returns a numeric value rounded down towards zero, to the nearest multiple of significance. Examples:
- floor(3.5, 2) rounds down to 2
|
floor([metric1], 2) |
ceiling(expression) |
Returns number rounded up away from zero. Examples:
- ceiling(10) rounds up to 11
- ceiling(10.5) rounds up to 11
- ceiling(10.7) rounds up to 11
|
ceiling([metric1]) |
ceiling(expression, expression) |
Returns number rounded up, away from zero, to the nearest multiple of significance. Examples:
- ceiling(10, 1) rounds up to 11
- ceiling(10.5, 2) rounds up to 13
- ceiling(10.7, 2) rounds up to 13
|
ceiling([metric1], 2) |