Marketscape™: Map Query Example

Exercise: To identify counties whose Hispanic population percentage is greater than 50%.

1. On the Data Settings tab:

   • For Geography select County. Country (Geo-0) was selected only for purposes of this exercise but Map Queries can be defined for any level of geography.

   • Click the Map Query tab.

2. For Year, select the desired Year check box.

3. For Data Type, select the Percentage check box.

4. Under Indicator, click to expand the American Marketscape DataStream database.

5. Click next to the to expand Geography, Population and Household Summary groups. Then expand, Population and Total & Hispanic. Various symbols may display next to indicators :

Symbol	Description
	Numeric indicator
	Percentage indicator
	Unlicensed indicator
	Uploaded data indicator
	Virtual indicator
	Disabled numeric indicator because indicator is not available at the geography level currently selected
	Disabled percentage indicator because indicator is not available at the geography level currently selected
	Disabled uploaded data indicator because currently selected geography does not match data uploaded
	Virtual indicator that has been shared with you

6. Double-click Hispanic Population % to select. The indicator is added to the Query Editor text area and the Minimum and Maximum values of the selected indicator displays above the Query Editor.

7. Click the > operator button.

8. In the Query Editor type 50%.

9. Click Run. Map in view displays only those counties that meet the criteria defined in query. That is, those counties whose Hispanic population makes up more than 50% of their total population.

10. In the submenu click and then select Map Report to get the list of countries in a tabular report.