Supported Functions and Operators in Visualizer Expressions
All functions and operators are supported in Advanced mode, with the exception of TRANSFORM.
A subset of BQL functions and operators are supported in the Visualizer Expression Builder Basic Mode, as listed below.
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.
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
Adding an Expression in
Visualizer
Logical Query
Language Functions