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
SimplyAnalytics Exhibiting at ALA Annual 2023!
Posted on May 24, 2023 by Admin
SimplyAnalytics is excited to attend. Swing by booth 1733 for a brief demo, and discover how our user-friendly demographics, business, health & marketing data analytics and visualizat...
SimplyMap Tip: Exporting Maps
Posted on May 15, 2015 by Admin
In this week’s SimplyMap report, we want to share with you the many options available when exporting maps in SimplyMap. In SimplyMap, when a user selects Export Map Image from the Actions...
York and Ryerson Universities Subscribe to SimplyMap Canada
Posted on Sep 10, 2010 by Admin
SimplyMap Canada is now available at several Canadian institutions, including York University and Ryerson University, in Toronto. SimplyMap Canada has all of the great features included i...
University of Washington Launches 9 new SimplyMap Tutorials
Posted on Apr 30, 2008 by Admin
Doreen Harwood, Business Librarian from the University of Washington has developed a series of detailed tutorials on using SimplyMap. The tutorials, which are Flash-based and interactive,...
Exploring SimplyMap Data: SimmonsLOCAL Lifestyle Statements
Posted on Jun 08, 2015 by Admin
In this week’s report we take a look at one folder found within SimplyMap’s SimmonsLOCAL data package. SimmonsLOCAL is a powerful targeting and profiling system that provides insights int...
From the Help Desk: How to Analyze all PRIZM Segments at Once
Posted on Dec 02, 2019 by Admin
Hi everybody! We’re back this week with another question from our Help Desk. This time featuring SimplyAnalytics Canada. Let’s get started! Question: How can I analyze all of the PRIZM5 s...
Rise of the Tablet
Posted on Nov 20, 2015 by Admin
In a previous blog we demonstrated the power of utilizing multiple years for the same variable. We found that the usage of Amazon.com had grown substationally from 2008-2014. In this week...
Feature Highlight - Jump to Path
Posted on Sep 28, 2018 by Admin
Welcome readers! Today we have a quick feature highlight that will assist you in browsing and searching for data variables. All data variables have a path where they reside within their d...
American Household Spending on Pets
Posted on Dec 09, 2014 by Admin
In this week’s SimplyMap blog post, we set out to discover which large US cities spend the most money per year on their pets. To find this out we used the variable, “Pets, Household Avera...
Visit GRI at PLA Conference in Portland March 24-26
Posted on Mar 09, 2010 by Admin
The GRI team will be exhibiting at the 2010 Public Library Association conference later this month at the Oregon Convention Center in Portland, OR. The PLA National Conference is the prem...