Knowledge Drop

Can we apply pivot over dimension?

Userlevel 3

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.                



0 replies

Be the first to reply!