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 ;;
}
*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
LinkedIn
Twitter