I’m trying to write some LookML to have column headings in a visualisation show the value of the pivoted row above the column headings.
Example:
The pivoted row (Question) is from a View called metadata and the value is from metadata.key_description.
The column headings are from the below measure and I have attempted to use liquid variables to have dynamic values:
measure: value_list {
label: “{{ metadata.key_description._value }}”
type: list
list_field: value
}
When I use metadata.key_description._name, the column headings display as “metadata.key_description”, so I seem to be on the right track.
Is Looker able to reference changing values in a pivot row to change the label of the column headings below the pivot?