#
Materialized Keys
Materialized keys are the result of calculations on one or multiple existing keys in your events.
#
Reference
Materialized keys work a lot like Excel functions. A materialized_key
consists of:
- one or multiple existing
key
s ormaterialized_key
s prefixed with$
. Example:$@duration
- a function. Example:
MIN
to compute the minimum between two values - numbers: Example:
32
Materialized keys can only take existing key
s of type number
.
Example materialized_key
: LESS(PLUS($@duration, $@initDuration), 100)
. This will return true for every event where the sum of the @duration
and @initDuration
is less than 100
.
#
List of operators
#
Comparison operators
LESS
: less thanLESSOREQUALS
: less than or equalGREATER
: greater thanGREATEROREQUALS
: greater than or equalEQUALS
: equalNOTEQUALS
: not equal
#
Math operators
MIN
: minimumMAX
: maximumPLUS
: sumMINUS
: subtractMULTIPLY
: multiplyDIVIDE
: divideMODULO
: modulo