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

  • =Count([Response ID_XX])

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: If your data is not automatically associated, you can search for your location by hitting the down arrow, choose Select Location..., and searching for your needed location

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.

Did this answer your question?