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.

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.

track performance on a map

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”.

track performance on a map

 

You can use eSpatial to aggregate all the values associated with individual owners. Using this type of analysis would return a map like this:

 

track performance on a map

 

In the above map, the colored pins indicate individually plotted values associated with the different owners:

 

track performance on a map

 

The table at the bottom then aggregates all individual plotted values associated with each owner.

 

track performance on a map

 

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:

 

track performance on a map

track performance on a map

This provides a composite performance visualization that can be easily shared across the internet:

track performance on a map

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:

track performance on a map

 

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):

track performance on a map

 

So here the pins will be colored according to status (as indicated in the dropdown):

track performance on a map

 

The value of each status is aggregated on the table:

 

track performance on a map

 

And, finally, the bar chart visually expresses the value level of each status:

track performance on a map

Click to interact with our sample Leads, Prospects & Opportunities map:

track performance on a map



Related Content