Can we apply pivot over dimension?

Looker Q&A Looker
, ,
1

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

​

2

I use this for a list of hyperlinks. However, when pivoted the links are not working anymore. Can you help with this?

  dimension: image_link {
    type: string
    sql: ${TABLE}.image_link ;;
    link: {
      label: "Image in Platform"
      url: "@{link_image_platform}"
      icon_url: "@{link_favicon}"
    }

  measure: image_link_list {
    type: list
    list_field: image_link
  }