Filter Table - Hone in on Areas of Interest in Your Data

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:

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.

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 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.

Improved Visualization

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

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.

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.

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).

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.

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.

Get Started With eSpatial Today