Functions in Analytics
These functions are only available for ClickHouse and Elasticsearch Queries. See the full description link from the table for limitations of nesting operations.There is no support for EventDB queries and rules.
The following functions are available:
Type |
Functions |
---|---|
AVG, COUNT, COUNT DISTINCT, FIRST, LAST, MAX, MEDIAN, MIN, MODE, PctChange, PCTILE, Pctile95, STDDEV, SUM, VARIANCE |
|
DeviceToCMDBAttr |
|
LOG, TO_DOUBLE, TO_INTEGER, TO_STRING |
|
DayOfWeek, HourOfDay |
|
IF |
|
EXTRACT |
|
LookuptableGet, LookupTableHas |
|
LEN, LTRIM, REPLACE, RTRIM, SUB_STR, TO_LOWER, TO_UPPER, TRIM, URL_DECODE |
|
EMA, SMA |