Filter table

The filter table is the go-to function when you want to refine your analysis to hone in on areas of interest in your data

Sign up for a free 14-day trial
Filter table
What is a filter table
Video transcript for What is a filter table

The filter table mirrors your spreadsheet, making it easy for you to sort the data on your map.

So, for example, I want to hone in on this drivetime analysis to just see the leads that are in the Houston area. So I select my dataset of choice, and I filter to the city.

And there I have all of the points in Houston.

What is a filter table?

The filter table mirrors your spreadsheet, making it easy to sort the data on your map. It is a tool that helps you focus on specific subsets of data based on your criteria, making it easier to analyze and visualize relevant information.

Here's how it typically works:

Filtering data by specific US state

Data filtering

Users can create filters based on certain attributes or characteristics of their data. For instance, if you only want to see the data in a specific state, the filter table can hone in on your chosen location in seconds.

Filtering by sum total

Conditional criteria

Use conditional criteria to set filters in a filter table. These criteria may include numerical conditions (such as values greater than or less than a certain number), string matching (such as cities with a specific name), or date ranges.

Dynamic updating of data Dynamic updating of data

Dynamic updates

As users apply filters, the map and associated data table dynamically update to reflect the filtered results. It allows for real-time exploration of data subsets without modifying the underlying dataset.

Focus on data within New York city

Improved visualization

When dealing with complex geographic information or large datasets, quickly focus on specific aspects of data, reducing clutter and improving map clarity.

Analyzing location data

Analytical insights

Filtering allows users to extract specific insights or patterns from data, uncovering trends, correlations, and outliers in the selected subset.

In essence, a filter table is a tool that enhances the interactive and analytical capabilities of mapping software. It allows users to tailor their visualizations to highlight the information most relevant to their analysis or presentation.

How to apply a filter to your dataset

You can use filters to analyze your map data in more depth, allowing you to delve deeper into your data. For instance, you can filter by customers residing in a particular area with a specific income level.

There are three types of filters:

  • Numerical
  • Text
  • Date

By default, the table collapses at the bottom right corner of the screen.

1. Numeric filters

Step 1

Click the Table button to expand it.

Table button

Step 2

Select the dataset/column you wish to filter in the table. Select the Filter button at the top of your filter column. It opens the filter window beside the table.

Filter data based on column values

Step 3

You can adjust the minimum and maximum values by entering the numbers or using the up/down arrows that appear when you hover over the number field. Click on the X icon to remove the filter(s).

Numbers based filtering

2. Text filters

Step 1

If the Column is a text field with less than 50 distinct values, the filter window will appear as below. It allows you to choose one or more values.

Filtering based on pre-defined text values

Step 2

Click on All to remove or add all results to the map or click on one or more choices to add or remove them from the map.

Step 3

Click on the X icon to remove the filter.

3. Date filters

Step 1

You can filter based on a range of date values. At the Add Data stage, make sure your data's date column(s) have been correctly formatted.

Date based filtering

Step 2

You can specify the start and end dates of the data you want to view using the From and To dates.

Date based filtering with the input field calendar visible

Step 3

Click on the X icon to remove the filter.

You appear to be offline at the moment, this notice will disappear once your device can connect to the internet again