Data Manipulation Enhancements

Row-level functions and expressions can now be used in WHERE clauses in custom metrics.

In a custom metric, WHERE clauses allow you to specify a formula without first creating a derived field. The WHERE clause must be in the leftmost part of the custom metric expression, but it can be expressed with a row-level function or any of the aggregate functions available for custom metrics. In the following example, the total planned sales is calculated for men.

SUM(plannedsales) WHERE UPPER(gender) = 'MALE'

See Supported SQL-Like Expressions.