Hierarchical Filters

mcdoa
New Member

Hello I have a question about having filters affect the results you see in other filters inside of Looker.

So far I’ve been trying without success, but in short, I am trying to do the following: I have the following hierarchy chart:

It starts with the three teams at the top - this would ideally be the first filter, with those three options.

However - if I choose Product Team - Filter 2 should only show Product Manager 1 and Product Manager 2 - it should not show the other positions at that level.

And the same logic for filter 3. I would first select Product Team, then I could select Product Manager 1, and then I would have the choice of Product Invididual 1 or 2 in Filter 3.

7d4de6eb-4276-4b01-bd8c-3f5c27fa114c.png

Is this possible to do inside of Looker? Right now, when I select Product team and go to Filter 2 - I can still see all the Engineering Manager roles. And - this has been abstracted - in the real case, there would be a 20+ options at Filter 1, 100+ at level Filter 2 (before it is filtered by Filter 1), and 1000+ at level Filter 3 (before it is filtered by Filter 2).

Any help would be much appreciated!

Thank you!

1 2 2,460
2 REPLIES 2

siu
Bronze 3
Bronze 3

I have the same question as well. This is quickly becoming a blocker for us to user Looker in our embedded product. Need a solution for this as soon as possible. 

I came across a way to do this in dashboards via setting up linked filters: 

 
My organization would also like to have a version of this functionality within an explore, but this dashboard solution is helpful. 
Top Labels in this Space