Can we apply pivot over dimension?

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 ;;

}

*NOTE
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