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

Aggregate Functions

AVG, COUNT, COUNT DISTINCT, FIRST, LAST, MAX, MEDIAN, MIN, MODE, PctChange, PCTILE, Pctile95, STDDEV, SUM, VARIANCE

CMDB Lookup Function

DeviceToCMDBAttr

Conversion Functions

LOG, TO_DOUBLE, TO_INTEGER, TO_STRING

Date Conversion Functions

DayOfWeek, HourOfDay

Evaluate-and-Set Function

IF

Extraction Function

EXTRACT

LookupTable Functions

LookuptableGet, LookupTableHas

String Manipulation Functions

LEN, LTRIM, REPLACE, RTRIM, SUB_STR, TO_LOWER, TO_UPPER, TRIM, URL_DECODE

Time Window Functions

EMA, SMA