Bubbles on a map

Dashboard

Data

Configuration

Revenue per Country

​​​Displays revenue aggregation by country as bubbles on the map.

Data Source

• SharePoint List
  List: Orders
  Fields: ​​Total, Customer:Country, Customer:CountryLongitude, Customer:CountryLatitude
  Rows: 2000

• Aggregation:
  Group by: location

  As you can see the location field doesn’t exists in the data source. We assign it in the JavaScript code in the advanced panel (see below).

  Aggregations:
  Total = sum of Total
  Latitude = min of Customer:CountryLatitude
  Longitude = min of Customer:CountryLongitude
  Country = min of Customer:Country
  

• Advanced:

  var handlers = {};
  handlers.requestSuccess = function(data, logger) {
  $.each(data.items, function() {
      this.location = this.Customer_x003a_CountryLatitude + '_' + this.Customer_x003a_CountryLongitude;
  })
  return true;
  }

  This bit of code is used to assign the location field that is used as a group by value. The location field has the format of CountryLatitude_CountryLongitude.

Dashboard

• Chart
  Type: Map with bubbles
  Latitude: Latitude
  Longitude: Longitude
  Value: Total

• Style
  Size: 100% x 600

  Width x height dimensions of the map. Default units is px.