The pivot_where
function can be used in a table calculation to select a pivot column by a condition.
Syntax
pivot_where(select_expression, expression)
The pivot_where
function returns the value of expression
for the pivot column which uniquely
satisfies select_expression
or null
if such a column does not exist or is not unique.
Examples
In the following example we look for the pivot column that is based on "Order Status", and has a value of "pending". If we find it, return the "Order Count" in that cell:
pivot_where(${orders.status} = "pending", ${orders.count})
Things to know
If there is exactly one pivot column where
select_expression
is true, theexpression
is returned. Otherwise theexpression
returns NULL.pivot_where
cannot be used in a custom filter.