ETO Results | Geographic Charts

BO 4.3 Platform

Updated over a week ago

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 or any other value

  • =Count([Participant Site Identifier])

  • =Count([Response ID_XX])

Step 2: Edit as a Geography

Select your location object, select the 3 Dot button, and select Edit as a Geography 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. Highlight the table > Report Element Data panel > Display Feeding panel > Turn Into > Geographic selection

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 measured 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 measured 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 screenshot gives a zip code breakdown for each of the three counties being served.

Did this answer your question?