hello, I have a customizable dimension label based on a user attribute and I am having trouble using that value as a filter title in a LookML dashboard. Any help or direction is appreciated.
for example I have a dimension such as this:
dimension: department {
label: "{{ _user_attributes['ua_department'] }}"
type: string
sql: ${TABLE}.department ;;
}
Where the label can be various values that have context for our users (team, division, squad, etc). This works as expected when users view an SSO embedded url dashboard with the relevant user attribute attached. The values within the dashboard reflect the label of the dimension that the user expects to see.
However, If a dashboard is created that uses that dimension as a filter, the filter title will reflect whichever value that dimension has for the original user that created the dashboard. So, in many cases, the filter does not have meaningful context for the viewer.
I am using LookML dashboards so the LookML ends up with a hard coded value for the filter title
filters:
- name: Division
title: Division
type: field_filter
default_value: ''
allow_multiple_values: true
required: false
ui_config:
type: advanced
display: popover
instead of "Division", I want the title and name of the filter to be the value of {{ _user_attributes['ua_department'] }}
Can anyone offer any suggestions on how to achieve this? Thank you