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 trial
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.
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:
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.
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.
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.
When dealing with complex geographic information or large datasets, quickly focus on specific aspects of data, reducing clutter and improving map clarity.
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.
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:
By default, the table collapses at the bottom right corner of the screen.
Click the Table button to expand it.
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.
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).
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.
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.
Click on the X icon to remove the filter.
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.
You can specify the start and end dates of the data you want to view using the From and To dates.
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