Dynamically creating/accessing the Chart while visualizing the dashboard in Google Data Studio

Question

We are trying to display two pie Charts in the default Dashboard and when user clicks on one of these pie-charts the data-table of the selected pie-chart should overlay/override on other pie-chart dynamically.

For example:

• The dashboard displays two pie-charts by default. The pie-chart on the left side display the employee and salaries data. The right side pie-chart will have the employee and locations data.
• When user clicks on the left pie-chart, the right pie-chart should be overlay/override by a bar-chart OR data-table which contains the employees' hierarchy, organization hierarchy with salaries. And user clicks outside the pie-charts the default view with two pie-charts should display.
• Similarly when the user clicks on the right side pie-chart, the left side pie-chart should be overlay/override by different bar-chart OR data-table which shows the employees and their working locations.

Please find the attached screenshots in reference to the above example.

Default Dashboard

After the user clicks on the left side pie chart in the default dashboard

We tried available filters but they works with in the graph/chart, but not overriding existing graph with another graph. Please guide us on how to achieve the dashboard.

Answer 1

The current native charts and feature set does not enable changing chart types on the fly in view mode.

That being said, you can create your own customized chart in javascript that will let you do this.

Alternatively, if clicking does not require filtering of the data, you put a transparent box on top of each pie chart and hyperlink to separate pages with the correct charts.