This article describes how to consolidate existing data using auto-calculated data columns.
Related article: View data in tabular form.
Map Business Online comes with rich set of demographic data. Demographic data is often organized into predefined ranges. For example: population by age or households by income. What if you need to combine several ranges for your market analysis? For example your typical customers are 20 – 29 years old. But Map Business Online only offers population data for 20 – 24 and 25 – 29 ranges. Here are auto-calculated data columns come in to play. You can use these data columns to consolidate ranges data.
Another application of auto-calculated data is visualizing market penetration. With auto-calculated data columns you can simply divide number of customers you have in a ZIP code by total population of that ZIP code or population of certain age in that ZIP code.
Consolidate several demographics ranges into one as following:
This example shows how to calculate market penetration: