I'm trying to implement a drill-down feature in my Looker Studio dashboard where:
Current Behavior:
When I drill down on a specific name of Business Line in Business Line column in my chart widget, it shows all Advertisers across all Business Lines. This happens even when I click on a specific Business Line value in that Business Line column.
Desired Behavior:
When drilling down on a specific Business Line value, it should only show Advertisers assigned to that selected Business Line. Other Advertisers should be filtered out.
Has anyone implemented this kind of filtered drill-down? What's the best way to set up the relationship between Business Line and Advertisers to achieve this?
LinkedIn
Twitter
