← Analytics / analytics / analytics-engine / sql-reference

Conditional functions

Usage:

if(<condition>, <true_expression>, <false_expression>)

Returns <true_expression> if <condition> evaluates to true, else returns <false_expression>.

Example:

if(temp > 20, 'It is warm', 'Bring a jumper')