Can we apply pivot over dimension?

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

29d3fd4d-178a-44cd-bbe5-68c803350b2d.png

*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 as shown in the example below:

39930451-b2cd-4e13-a846-19c5d156d0d6.png
0 1 785
1 REPLY 1
Top Labels in this Space
Top Solution Authors