Combine a Map, a Table and a Chart
Use eSpatial Aggregate by Value analysis to combine a map, table and chart. Create a powerful visualization that can be embedded in a website or shared via email. Use to track performance on a map.
Aggregate by Value
Aggregate by Value analysis is a fast, simple method of tracking how people, products, campaigns – anything you can map – are performing across a geographic region.
How aggregate by value works in eSpatial. Data is plotted and can then be aggregated in a table, according to owner, status, campaign, etc. It’s a simple clear method to track performance on a map.
How it works
If you have different values in a spreadsheet column that you upload to eSpatial, Aggregate by Value analysis will add up those values, according to their title. Let’s take the sample dataset file you can access via the eSpatial upload wizard (new users can sign up for a free account and access this file here). The sample data contains a column for “Value” and for “Owner”.
You can use eSpatial to aggregate all the values associated with individual owners. Using this type of analysis would return a map like this:
In the above map, the colored pins indicate individually plotted values associated with the different owners:
The table at the bottom then aggregates all individual plotted values associated with each owner.
Enhance the map with a chart. Click on the Add Chart button (on the top bar of the data table) and you can chart the aggregated data in a variety of styles. A pie chart or a bar chart, for instance:
This provides a composite performance visualization that can be easily shared across the internet:
Sort and total values by status
Returning to the Sample File above, you’ll notice that there was also a “Status” column in the spreadsheet:
In the same way that we created a map that sorted values by owner, we can create a map that sorts values by status (Prospect, Lead or Opportunity):
So here the pins will be colored according to status (as indicated in the dropdown):
The value of each status is aggregated on the table:
And, finally, the bar chart visually expresses the value level of each status: