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 →

Want to talk this through with other Domo practitioners?

free Slack community — not affiliated with Domo, Inc.

💬 join the Domo User Group →

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 →