I have a list of manufacturers and models. When the user filters on manufacturer, I would like the model filter to display only models for the selected manufacturers.
I can do this in user dashboards but I don’t see how to do in LookML dashboards.
Cascading filters on LookML dashboards
Hello,
how does it work filtering down to the next tier?
do i need another tag:
listens_to_filters: [“city”]
listens_to_filters: [“state”]
or will the [] act as an array: listens_to_filters: [“city”, “state”]
What happens on the third tier if i selected a city but not a state then went to filter on the third tier?
I have found when using the above that in the dashboard when i select a city the states filter fine, however if i then remove the city in a bid to filter on all states that my last filter on city prevails and i am presented with only the restricted list not the full list of options (as city hasn’t been specified)
Userlevel 2
- Looker Staff
- 24 replies
-
26 July 2016
Hey Sonny,
Here is the LookML syntax to use for this functionality:
- name: state
title: "State / Region"
listens_to_filters: ["city"]
type: field_filter
explore: users
field: users.state
This is not currently documented but we are working to get this in the docs, thanks for pointing that out!
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.