home User Guide Getting Started Help Center Documentation Community Training Certification
menu
close
settings
Looker keyboard_arrow_down
language keyboard_arrow_down
English
Français
Deutsch
日本語
search
print
pivot_where Function

keyboard_arrow_leftBack to Functions and Operators

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

  1. If there is exactly one pivot column where select_expression is true, the expression is returned. Otherwise the expression returns NULL.

  2. pivot_where cannot be used in a custom filter.

Top