To create more complex conditions based on mathematical operations, it is possible to use the formula editor.
Formulas input
To use formulas:
- Switch to the manual input mode
Enter the metric name in the Data source field or select it in the filtered list of options. The name of each metric must be written in braces as follow: {{metric_name}}.
- Input the formula using mathematical symbols, constants and braces.
For example, the difference between the maximal round-trip time and of minimal round-trip time:
{{roundTripMaximum}} - {{roundTripMinimal}}.
The result of calculations will automatically be displayed over the entered mathematical operation.
Available operations, operators and functions
Operations
Operation | Description |
---|---|
! | Factorial |
^ | Exponentiation |
* | Multiplication |
/ | Division |
% | Remainder of division |
+ | Addition |
- | Substraction |
|| | Concatenation |
== | Equal |
!= | Not equal |
>= | Greater or equal |
<= | Less or equal |
> | Greater |
< | Less |
and | Logical AND |
or | Logical OR |
not | Logical NOT |
Operators
Operator | Description |
---|---|
x! | Factorial (x * (x-1) * (x-2) * … * 2 * 1). gamma(x + 1) for non-integers |
abs x | The absolute value of x |
ceil x | Round to the next integer |
floor x | Round to the previous integer |
length x | String length of x |
round x | Round to the nearest integer |
sqrt x | Square root of x |
trunc x | Remove the fractional part of x |
exp x | e^x (exponential/antilogarithm function with base e) |
ln x or log x | Natural logarithm of x |
log10 x | Base-10 logarithm of x |
acos x | Arc cosine of x (in radians) |
acosh x | Hyperbolic arc cosine of x (in radians) |
asin x | Arc sine of x (in radians) |
asinh x | Hyperbolic arc sine of x (in radians) |
atan x | Arc tangent of x (in radians) |
atanh x | Hyperbolic arc tangent of x (in radians) |
cos x | Cosine of x (in radians) |
cosh x | Hyperbolic cosine of x (in radians) |
sin x | Sine of x (in radians) |
sinh x | Hyperbolic sine of x (x is in radians) |
tan x | Tangent of x (in radians) |
tanh x | Hyperbolic tangent of x (x is in radians) |
x ? y : z | Ternary conditional (if x then y else z) |
Functions
Function | Description |
---|---|
random(n) | Get a random number in the range [0, n). If n is equal to zero, or not provided, it defaults to 1. |
min(a,b,…) | Get the smallest (minimum) number in the list. |
max(a,b,…) | Get the largest (maximum) number in the list. |
hypot(a,b) or pyt(a, b) | Hypotenuse, i.e. the square root of the sum of squares of its arguments (sqrt(a^2+b^2)). |
pow(x, y) | Equivalent of exponentiation x^y. |
atan2(y, x) | Arc tangent of x/y. i.e. the angle between (0, 0) and (x, y) in radians. |
if(x, y, z) | Equivalent of the ternary conditional (if x then y else z). |
delta(x) | Difference between the current and the previous value of the x. |
deltaRoll(x) | Only positive difference between the current and the previous value of the x. Negative value is replaced with the last non-negative result. |
timestamp() | Timestamp of each metric from the returned series of values. The format is 13-digit integer value (milliseconds). |