Go up
Using Multiple Filter Conditions
Posted on Apr 14, 2016 by Admin
This week’s SimplyMap report will provide an overview of one of the more advanced functionalities in SimplyMap - applying multiple filter conditions. Filters can be applied to any map or report tabs. For example, a map showing Household income levels by ZIP Code could be filtered to only show ZIP Codes with income over a specific threshold. Another example would be to filter the same income map to only show ZIP Codes with a population over 8,000. Using multiple filter conditions is a great way to hone your focus on a narrower set of geographic locations that meet your multiple criteria. Let’s get started with an example.
Scenario: You are looking for the best location to open up a high end salon in California and want to develop an initial list to further analyze. Let’s assume there are three criteria that must be met before considering a location.
1. The location has to have more than 500,000 residents.
2. The location must have a median household income of at least 75,000.
3. At least 30% of households must report spending money at a salon.
The Setup: First, create a new Location Analysis Report and set your location to California. Next, navigate through some pertinent variables and add the following variables that will serve as our criteria.
# Population, Total (Census Data » People and Households » Age » Total)
Household Inc., Median (Census Data » People and Households » Income » HH Income)
% Households Buying - Expenditures: Amount Spent In Total: Beauty Parlor (MRI Consumer Survey » Purchasing » Average HH Spending)
After you have added all variables you are interested in, close out the Variables panel to generate your report. Results below:
Your initial results will display all counties in California. To create a filter, click on Data Filters > Create New Filter from the top right of SimplyMap. The filter creation dialog will open up.
NOTE: The only variables that will show up as possible filter criteria in the variable dropdown will be either recently used variables, or favorite variables. In this case, we have the variables already in the report, so by default they will show under recently used variables.
1. Select the first dropdown and click on the beauty parlor variable. Leave the second dropdown to “is greater than” and enter a value of 30 in the last box.
2. Click on Add Another Condition to bring up a second variable selection box - choose the population variable and set that to “is greater than” 500,000.
3. Lastly, click on Add Another Condition once more, and find the Median Household Income variable - set this value to “is greater than” 75,000.
Give your filter a name, and click on SAVE to apply it onto your report. New results below!
Locations that do not meet your three conditions are then struck out with a line and seen in light gray. If you’d like to hide these locations, click on Display Options > Filtered Locations > Hide. Your final report is shown below:
Only 7 of California’s 58 counties meet our specific criteria.
A logical next step for someone doing market research would be to analyze specific ZIP Codes or census tracts within these counties more in depth, and run business reports to see what the competition is like in the target areas.
Do you have any questions on creating and applying filters? Feel free to leave a comment below or send as an email at: support@geographicresearch.com
More from SimplyAnalytics
American Community Survey Data in SimplyAnalytics
Posted on Jun 21, 2022 by Admin
Hello readers! We hope you’re having a great day. Today we are featuring 5 commonly asked questions about the American Community Survey dataset that’s available to all customers in Simply...
GRI Exhibiting and Presenting at North Carolina Library Association, October 4-7
Posted on Sep 07, 2011 by Admin
Geographic Research will be exhibiting and presenting during a vendor showcase session at the upcoming North Carolina Library Association (NCLA) Biennial Conference, October 4-7, 2011 in ...
Michigan State University Offers SimplyMap Training
Posted on Jan 18, 2009 by Admin
Michigan State University is offering their users a basic introduction to using SimplyMap. The 1.5 hour session will cover the basics of how to use SimplyMap to create maps and reports u...
Visualizing Brand Preference: Mayonnaise
Posted on May 10, 2016 by Admin
One benefit of data and applications like SimplyMap is the ability to visualize information. In this week’s report, we’ll take a quick look at some branding preferences in contiguous Amer...
The Most Socially Networked Cities in America
Posted on Mar 21, 2011 by Admin
Men's Health magazine decided to crown one town America's Most Socially Networked City, and has generated quite a buzz in the process. Their survey examined the number of Facebook and Li...
SimplyMap 3.0 Tip - Using the Data Filter
Posted on Oct 24, 2014 by Admin
At times it can be useful to apply filters to the data in SimplyMap as a means of focusing on specific characteristics, or preforming a query. For example, a map showing household income ...
Exploring SimplyMap Data: America’s Historic Homes
Posted on Jan 07, 2015 by Admin
In this week’s exploration of SimplyMap data, we set out to find which cities in the United States have the highest percentage of older houses. To determine this, we used the variable “% ...
SimplyMap Makes CHOICE Outstanding Academic Title List
Posted on Mar 14, 2010 by Admin
The GRI team was honored to learn that SimplyMap was included in this year's Choice Outstanding Academic Title List, published in the January 2010 issue of Choice Magazine. This is a grea...
UNCG Dataland Blog offers new SimplyMap Tutorial Videos
Posted on Aug 22, 2009 by Admin
Lynda Kellam, the Data Services & Government Information Librarian at the University of North Carolina, Greensboro has produced some new tutorial videos to help students learn how to ...
Veterans in the United States
Posted on Nov 11, 2014 by Admin
With Veteran’s Day in the US this week, we thought it would be an ideal time to explore some of the variables in SimplyMap that pertain to veterans. Specifically, we wanted to know which ...