View the original community article here
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 ;;
}
*NOTEtype: 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.