Viewing Co-ordinate Maps with Pie charts

Map charts are used to display co-ordinate maps based on the related data of a worksheet. To view the map with Pie charts, select a worksheet for which the:

  • Report source: Embedded
  • Report Type: pivot_editor
  • rv_chart_number: 9

The rv_map_type parameter is used to display the map chart. To ensure that coordinate maps are displayed as required, these parameters must be specified:

  • rv_map_show_pie: Must be set to TRUE to display pie charts at the specified co-ordinates on the maps. If set to FALSE, bubbles are displayed on the map.
  • rv_map_latitude: Used to determine the latitude coordinate on which the data must be displayed.
  • rv_map_longitude: Used to determine the longitude coordinate on which the data must be displayed.
    Note:  The rv_map_continent_atrr, rv_map_country_atrr, and rv_map_province_atrr are optional parameters that are only used to determine the most appropriate map type to be displayed.
  • Locations must be specified in the first dimension in the rv_left_dim parameter.
  • Items must not be specified in the rv_left_dim parameter.

Display functionality:

  • When the pies are displayed in the map, the charts are used to plot data for each co-ordinate (the rv_chart_rows parameter is ignored). The map is used to plot data for each pie chart based on the first measure which is specified or the selected measure, in the pivot (in rows or columns) for each location.
  • Each pie chart displays a segment for a combination of each top dimension of the selected measure.
  • Selecting a different cell in the grid does no effect the display of the pie charts in a map. Only selecting a different measure updates the pie charts.
  • If you click a pie chart in the map, the selected chart is displayed in a separate window. You can also click or hover over each individual segment to view the actual values.