Combining an Address Field in a TouchPoint with Geographic Charts in ETO Results can create useful, visual aids to track various kinds of address data.
Create your objects and charts
Step 1: Bring in necessary address objects
With your flattened TouchPoint data, bring in all of your necessary location objects: City, County, Zip Code, etc.
Note: You'll also need to create a variable to have a convenient way to count your Participants or responses
=Count([Participant Site Identifier])
Step 2: Edit as a Geography
Select your location object, right click, select Edit as a Geography, and choose By Name.
From there, you'll need to select your level
Country is the equivalent of country
Region is the equivalent of states
Sub-Region is the equivalent of counties
City is the equivalent of cities
Step 3: Define your data
You will have to associate all of your data to the corresponding area, be it the country, state, county, or city it belongs in.
Note: The system will not recognize zip codes that are associated with counties. Therefore, you will need to manually enter each zip code's county by clicking on the down arrow, searching for your desired county, pressing Enter or clicking on the Binoculars icon, selecting the correct entry under Location, and clicking OK.
If the Level is set to City, the same process works for associating zip codes to cities.
Step 4: Turn the table into a Geo Chart
Choose the Location object and the count variable and pull them into a table. Right click on the entire table and choose Turn Into > More Transformations > Geographic
Types of Charts
There are three different types of Geographic Charts to choose from: Choropleth, Bubble, and Pie
Geo Choropleth Chart
Values are represented by colors on a geographic map. the colors of the zones are determined by a measure value.
This map is best for defining by country, state, or county
Geo Bubble Chart
Values are represented by bubbles. The size of the bubbles is determined by a measure value.
This map is generally best for displaying population densities.
Geo Pie Chart
Values are represented by pies. The size of the pie is determined by a total measure value, and the size of the sectors is determined by individual counts.
This chart is best if you want to see how larger locations are broken up by more defined values. For example this screen shot gives a zip code break down for each of the three counties being served.