Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
Chapter 7 Have a go hero drill-down from the map to a chart Until now, we have created charts drilling down to more detailed charts, and maps drilling down to more detailed maps. In business reports and dashboards, you will often need to have a drill-down from a map to a chart or the other way round. Facilitate one of these cases by having a drill-down from the US map to a pie chart showing the category-wise breakdown of the items sold in the state. Choose the categories as you prefer--apparels, electronics, household items, and so on. Summary In this chapter, we learned how to create maps to display region-based geographical data. The maps are used in executive dashboards to display business data such as revenue by regions, census data such as population by state, and election results, effectively. Specifically we covered: How to create a simple map with range-based data having appropriate color codes How to map the IDs of entities stored in your internal system or database to the ones preset in FusionMaps How to create drill-down from one map to another, say continent to country or country to state In the next chapter, we will see how to select the right chart type for the data we have and the analysis we want to facilitate.