This topic lists information about what functions you can use in Spotfire, for example for writing custom expressions and adding calculated columns, when you work with in-database data tables from Dremio.
Date and Time functions
CURDATE, CURTIME, DAYOFMONTH, DAYOFWEEK, DAYOFYEAR, HOUR, MINUTE, MONTH, NOW, QUARTER, SECOND, WEEK, YEAR
Conditional
COALESCE, NULLIF
Math functions
ABS, ACOS, ASIN, ATAN, ATAN2, CBRT, CEILING, COS, COT, DEGREES, EXP, FLOOR, LOG, LOG10, MOD, PI, POWER, RADIANS, ROUND, SIGN, SIN, SQRT, TAN
Operators
+, -, *, /
Statistical functions
AVG, COUNT, MAX, MIN, STDDEV, STDDEV_POP, STDDEV_SAMP, SUM, VAR_POP, VAR_SAMP, VARIANCE
Text functions
CONCAT, INSERT, LCASE, LENGTH, LOWER, LTRIM, REPLACE, RTRIM, SUBSTRING, UCASE, UPPER
See also:
Accessing Data from Apache Drill and Dremio