Supported functions and operators in Visualizer expressions
All functions and operators are supported in mode, with the exception of Transform.
A subset of BQL functions and operators are supported in the Visualizer Expression Builder Basic Mode, as outlined in these sections.
Variable Syntax
When referencing a variable in BQL, for example in a report expression or an ETL script,
use the GETVARIABLE function:
GETVARIABLE('variable_name')
Do not use the V{} syntax.
This is supported in Expression Builder Basic Mode.
Logical
IIF
IFNULL
ISNAN
Math
ABS
CEILING
FLOOR
SQRT
EXP
POW
RSUM
MEDIAN
Dates
DATEADD
DATEDIFF
DATETIME
NOW
NOWDATE
Strings
FORMAT
TOLOWER
TOUPPER
SUBSTRING
LENGTH
TRIM
Lookups
STAT
Rank
RANK
Prompts and Variables
GETVARIABLE
GETPROMPTVALUE
Operators
+
-
*
/
=
<
>
<>
<=
>=
AND
IS NULL
IS NOT NULL
LIKE
NOT LIKE
OR