topic Pie chart Drill down to bar chart in Insight Advisor

Pie chart Drill down to bar chart

Abhishekb — Tue, 08 Aug 2023 04:57:11 GMT

Hei here,

Conversion: Pie chart to bar chart.

Drill down: Region->State->City name.

Question: When I select any region in Pie chart, for showing state wise measure it should convert to bar chart.

Kindly provide with solution. Thank you in advance.

- Abhishek B K

williejacobs — Tue, 15 Aug 2023 11:19:43 GMT

I would look at using a container and creating master Visualizations for the charts you want to use.

Then using the show condition can be used to hide the pie chart, Count(distinct Region) > 1
and the show bar chart where Count(distinct Region) = 1.

This should give you the same effect as a drill.

Abhishekb — Mon, 21 Aug 2023 04:08:16 GMT

Thanks for the Solutions.