I'm looking for a logic for a dashboard with a map and if click on any area of the map a related drilldown column chat should open.
We have areas and each area is having some regions.
Eg:-Area1-Chicago,Midway,City,Lake town. (Regions)
Map will show Chicago,Midway,City,Lake town regions separately and when we click on any of these regions ,a column chart should show up with all these regions in that area.
1.Map will show headcount of each region separately .
2.When we click on any region on the map,a column should show up with all the regions in that area.
I got the logic only showing one region at a time in the column chart when we click on anmap.
It would be great if somebody can provide me the logic how to do this.