Data Aggregation By Region

By
An often needed ability is to be able to combine or aggregate data for a region. For example being able to find the combined sales or averages sales of sales people in a particular region. With Scribble Maps this easily done using operations.

To get started you need two things present on your maps.

#1 Markers with attributes

You can upload these markers through our import list feature and the column values will be automatically added to each marker as attributes. You can also manually add attributes directly to a markers but this is not recommended if you are using large data sets.


#2 Region(s)

A region is nothing more than a shape (polygon). You can either draw them directly on the map, add them via a KML file, or use our region highlighter tool.

Aggregate That Data!


First go to the operations panel and then select either "In region" or "In multiple regions" in the aggregate column.


Next, select the group containing the regions you want to aggregate your data for and then which attributes you would like to aggregate and how. You can choose sum, average, or count. Finally click the "Aggregate Data" button.


Finally you will see the results of your operation which, in this example, is the sum sales for each region.

That's all there is to it to start aggregating data by region. This will hopefully help you with some of your spatial data analysis needs!

Comments

Post a Comment

Comments are moderated, thanks for your patience.

Popular posts from this blog

Route Optimization Comes to Scribble Maps

By
Image
Route optimization also known as the travelling sales person problem (TSP) is a type of routing to figure out which order you should visit locations in the fastest time possible. As you can imagine this is very useful if you need to drop off packages, do movie location scouting, make sales calls to a physical location, or need to do routine inspections. Well we are happy to announce that this functionality has now come to Scribble Maps. For demonstration purpose we have selected a bunch of different cafes in the Toronto region. Let's pretend that in the course of a day or multiple days you want to visit all of them. Here is a picture of the original points. Unoptimized Points From here we going to go to our Operations & Analysis panel and select Create > Optimized Route. Next you will want to select your start location, end location, and the way points folder that contains the points in your route. After clicking "Create Optimized Route" your
Read more

How to make a custom map

By
Image
There are many reasons why someone wants to create a map, but using the Scribble Maps online map editor , you can quickly make your own custom map where only your imagination is the limit. It would be impossible to go over every type of map you can create with Scribble Maps, but we will cover some in this post. If you want to hop in as quickly as possible, you can watch our first map video, which will go over all the basic tools you need to get started with Scribble Maps. Select or style the base map One of the first things you will want to do is set the base map or customize the existing one. For instance, creating a custom map style, such as a map without labels, click the custom bottom in the bottom right. Now you can turn off options like labels. Add drawings and markers to your map some of the most common things you may want to do are add drawings, markers, or text to your map. To accomplish this, all you need to do is select the tool you want in the toolbar and then click or drag
Read more

GIS Meets Fantasy — World Generator by Scribble Maps

By
Image
Fantasy maps have always been an integral part of the fantasy genre, providing a visual representation of the imaginary world in which the story is set in. These maps are often used to help readers navigate the world and understand the geography and political boundaries of the various kingdoms, cities, and other locations of the wider story. One of the most iconic examples of this is J.R.R. Tolkien’s map of Middle-earth, featured in his The Lord of the Rings trilogy. The map was created by Tolkien himself, which he used to keep track of the various locations and characters in his story. His map was also included in the first edition of The Lord of the Rings, giving readers a glimpse into the epic world of Middle-earth. Another famous fantasy map is the one from George R.R. Martin’s A Song of Ice and Fire series, which was prominently used in the opening credits of the popular series Game of Thrones. In video games, fantasy maps serve a vital role in immersing players into the captivati
Read more