How to use the filter app?

The Spotzi Filter App allows you to create advanced filters based on your data. This is very convenient if you quickly want to filter out data based on your characteristics. The Filter App is perfect for analyzing high-potential postal code areas or for creating interesting customer profiles of your data.

Create a filter based on a numeric field

In this example we will filter a sample of the US 5-digit ZIP code areas dataset containing total population and the total number of customers in that area. We are going to create a filter based on the number of customers in that area.

1. Open the map.

2. Now open the Filter App.

3. Choose the column that you want to use for creating your filter.

4. Pick a range. In this example I pick the areas where the total number of customers is between 15,000 and 18,322 (maximum number). It is also possible to add multiple ranges to your filter.

Ranges need to be of numeric data typeKeep in mind that you need a numeric field type in order to create ranges. This is well-documented in our article about data types. Remember that a postal code dataset sometimes contains postal codes of type text (string) . If you want to create a filter based on a specific postal code range you need to change the data type.

5. Press APPLY FILTER.

6. You have successfully added a filter to your map.

Create a filter based on a text field

In this example we will filter a sample of the US 5-digit ZIP code areas dataset containing total population and the total number of customers in that area. We are going to create a filter based on multiple area names.

1. Open the map.

2. Now open the Filter App.

3. Choose the column that you want to use for creating your filter.

4. Click SHOW VALUES to open the list with all available values.

5. Select the areas you want to show on the map.

6. Press APPLY FILTER.

7. You have successfully added a filter to your map.

Create a filter based on multiple fields

The true power of the filter app is the possibility to add multiple filters to your map. With these advanced filters you can filter and analyze data based on characteristics that are of interest to you. Create customer profiles based on your own custom filtering of the data and find out where your high potential customers are.

In the following example we will create an advanced data filter of our 5-digit ZIP code map with population and customer data. Within this dataset we will create a filter based on the total number of customers and the total population.

1. Open the map.

2. Now open the Filter App.

3. Choose the first column that you want to use for your filter.

4. Pick a range. In this example I pick the areas where the total number of customers is between 15,000 and 18,322 (maximum number). It is also possible to add multiple ranges to your filter.

5. Press ADD FILTER.

6. Choose the second column that you want to use for your filter.

7. Press APPLY FILTER.

8. You have successfully added a filter to your map.

Filter data by map layer

The Filter App also has the possiblity to filter data by layer. This allows you to only visualize areas within a certain buffer or only the addresses within a certain postal code area. In this example we will try to filter all the postal code areas that are located within a 60 minutes drive time range. This data is generated with the Drivetime App. To achieve this you have to take the following steps.

1. Open a new map and add the map layer with a drive time range and postal code areas.

Export data based on a filter

It is also possible to export your filtered selection to CSV, Shapefile, geoJSON, KML or XML. You can use these files to create filtered shapefiles of your data, but it is also possible to add these locations in bulk to your online marketing campaign (e.g. Google AdWords, Facebook Ads).

Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful. For more information about our cookie statement, please visit our Privacy Policy.

You can adjust all of your cookie settings by navigating the tabs on the left hand side.

Functional/Analytical Cookies

Functional Cookies should be enabled at all times so that we can save your preferences for cookie settings.

These cookies let us operate certain functions of the Spotzi Service in line with the choices you make. These cookies mean that when you continue to use or come back to the Spotzi Service, we can provide you with our services as you have asked for them to be provided, such as knowing your username, remembering how you have customised our services, and reminding you of content you have enjoyed.

We also use analytical cookies to analyse how the Spotzi Service is accessed, is used, or is performing. We use this information to maintain, operate, and continually improve the Spotzi Service.

disable

If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.

Marketing Cookies

We use these cookies that to track the pages that you have visited. Based on this information we can serve you offers that are completely adjusted to your interests.

disable

Please enable Strictly Necessary Cookies first so that we can save your preferences!