How to create a dashboard with Multiple filters which only apply to the Chart but don't cascade.

[Raj2005]

Hi All

This is my first attempt at using Looker Studio. I have created a dashboard to keep tab of some metrics for our products with many controls on top to filter data depending on the need.



I want the viewer to be able to see metrics for whatever level of filters they want. If they want to see sales in city X for brand A in category C, they can add those filters and the metrics are updated.

Issue I am having is that if the viewer selects these 3 filters, for each filter the looker studio is running 15+ queries to BigQuery and exhausting my quota.

All of these are controls. They are cascading and dependent on each other. If I select Brand XYZ, it only shows mfacs of that brand, category of that brand etc in their respective controls. While that is a handy feature, it is also running a separate query to BQ for each control leading to heavy quota usage.

I would like them to be independent of each other and only affect the Chart metrics. I don't mind seeing irrelevant dropdowns when choosing one dropdown, if needed. But the important thing is to avoid so many queries. A single view of sales of brand across 5 cities consumes 5GB of Billed Bytes. 


I have been banging my head trying to figure it out but cannot seem to find a solution for this.

Help pls.