Jae Wilson @DataCrew
Domo

PRODUCT DOCUMENTATION -- Supported Functions in Adrenaline Dataflows (Views and Beast Modes)

May 13, 2021

Note this is not a comprehensive list nor is it 'official'.

If you are unable to use a specific function in your implementation contact your CSM.  For example Median is not enabled out of the box.

Note most SQL-esque function implementations in Domo follow MySQL syntax -- except, obviously Redshift dataflows.

ADDDATE
ADDTIME
APPROXIMATE_COUNT_DISTINCT
APPROXIMATE_COUNT_DISTINCT_OF_SYNOPSIS
APPROXIMATE_COUNT_DISTINCT_SYNOPSIS
APPROXIMATE_MEDIAN
APPROXIMATE_PERCENTILE
AVG
CASE
CEILING
CONCAT
CONVERT_TZ
CORR
CORR
COUNT
CURDATE
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURTIME
DATE
DATE_ADD
DATE_FORMAT
DATE_SUB
DATE_TRUNC
DATEDIFF
DAY
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
FIRST_VALUE
FLOOR
FROM_DAYS
FROM_UNIXTIME
HOUR
IFNULL
INSTR
LAG
LAST_DAY
LAST_VALUE
LEAD
LEFT
LENGTH
LOWER
MAX
MEDIAN
MIN
MINUTE
MOD
MONTH
MONTHNAME
NOW
NTILE
NULLIF
OCTET_LENGTH
PERCENTILE
PERCENTILE_CONT
PERCENTILE25
PERCENTILE75
PERCENTILE99
PERIOD_ADD
PERIOD_DIFF
POW
POWER
QUARTER
RAND
RANK
REPLACE
RIGHT
ROUND
SEC_TO_TIME
SECOND
SQRT
STDDEV
STDDEV_POP
STR_TO_DATE
STRPOS
SUBDATE
SUBSTRING
SUBTIME
SUM
SYSDATE
TIME
TIME_FORMAT
TIME_TO_SEC
TIMEDIFF
TIMESTAMP
TO_CHAR
TO_DAYS
TO_NUMBER
TRIM
TRUNC
UNIX_TIMESTAMP
UPPER
VAR_POP
WEEK
WEEKDAY
WEEKOFYEAR
WIDTH_BUCKET
YEAR
YEARWEEK
INITCAP

NVL

Related

More posts on similar topics.

Got a project in mind?

hire me →

Getting value from the content but not ready to hire?

let's call it professional development

☕ buy me a coffee →

Want a practitioner take on Domo and AI, every month?

free, no spam, unsubscribe anytime

📰 subscribe to the digest →