Skip to main content
Use conditional functions to branch query logic based on evaluated predicates. They let you map values to labels, define alert tiers, or apply different transformations to different rows in a single expression.

List of functions

FunctionDescription
caseEvaluates a list of conditions and returns the value paired with the first condition that’s true.
iffEvaluates a single predicate and returns one of two values. iif is an alias.