Coming Soon! We’re launching a new sub-community within the Google Cloud Community dedicated to cloud security: The Google Cloud Security Community. In preparation for the launch, this site will be in read only mode from 22 September 12am PST - 23 September 7pm PST

Can we apply pivot over dimension?

Knowledge Drop

Last tested: Oct 14, 2020

Yes, we can by using type: list in Measure field.

measure: list {

type: list

list_field: first_name


dimension: first_name {

type: string

sql: ${TABLE}.first_name ;;


type: list creates a list of the distinct values in a given field. If two or more string value are included in the calculation, the data are separated by a comma.

Related Community post
- Pivot over dimension

Our Doc
- Measure Types - list

This content is subject to limited support.                

Version history
Last update:
‎07-07-2021 01:15 PM
Updated by: