...
The expression builder uses standard JavaScript syntax for Booleans, as follows:
Boolean value | Syntax |
OR | II |
AND | && |
NOT | ! |
Matching
The expression builder supports generic matches. For example:
...
Code Block |
---|
=IF([action] = "like", [like value], 0) # simple conditional
=IF([num likes] > [num loves], [num likes], [num loves]) # max of two columns
|
The first parameter can be any filter expression. The second two parameters, the “then” and “else” values, can be anything numeric, including timestamps.
Info |
---|
The IF function does not currently support strings or recognize enumeration values like "January", "Monday", flow step names, or termination reasons. |
Date math functions
Several relative time functions and calendar-aware functions are available. In addition, several existing functions are calculated based on the time zone set on your Scuba cluster. That is, these functions use a per-cluster time zone setting that is directly viewable and configurable only by contacting customer support or your technical account manager. If your cluster is configured to use UTC, the behavior of these functions won't change. But if it's configured to use some other time zone, these functions honor that time zone.
...