LinkedIn
Twitter
Hello Community!
Our company categorizes work by product area and product subarea. I have a dashboard with linked filters where the product subarea options are based on the selected product area. I followed the steps found in the documentation here: https://cloud.google.com/looker/docs/filters-user-defined-dashboards#how_to_link_filters.
However, when I select the product area, then go to select the product subarea, I get a message of 'No values' even though I know there are subareas available in the selected product area. My dimensions are set up as below. The raw data is product_area_with_subarea and I create dimensions based on this dimension. The product_area_with_subarea is not used directly in any of the looks on the dashboard. Any ideas are greatly appreciated!
dimension: product_area_with_subarea {
group_label: "Custom Fields"
type: string
sql: ${TABLE}.product_area_with_subarea ;;
}
dimension: product_area {
type: string
sql: split(${product_area_with_subarea}, ' - ')[offset(0)] ;;
}
dimension: product_subarea {
type: string
sql: CASE
WHEN CONTAINS_SUBSTR(${product_area_with_subarea},' - ') THEN split(${product_area_with_subarea}, ' - ')[offset(1)]
ELSE NULL
END ;;
}
