Filter and Table View
How to use the table to sort, filter, and search your data, and how map and table stay in sync.
The table view is where you work with your data as numbers, not just as colors on a map. You can sort by any column, filter by conditions, and search across all values. The map and table stay in sync at all times.
Sorting
Click any column header to sort. Click once for ascending, again for descending. The active sort column shows an arrow indicator.
Sorting works numerically for numeric columns and alphabetically for text. Sorting resets pagination to page 1.
Filtering
You can filter any numeric column by condition:
| Condition | Example |
|---|---|
| Greater or equal (>=) | Population >= 500 |
| Less or equal (<=) | Competitors <= 2 |
| Equals (=) | Purchasing power index = 100 |
| Not equal (!=) | Count != 0 |
| Between | Population between 200 and 1000 |
To add a filter:
- 1Click + Add filter in the table toolbar.
- 2Select the column you want to filter.
- 3Choose the condition from the dropdown.
- 4Enter the value and press Enter (or click outside to close).
Active filters appear as pills above the table. Click a pill to edit it. Click the × on a pill to remove it.
Filters persist when you save the Mapbook. The next time you open it, your filters are restored.
Searching
The search field filters rows by matching any visible value, case-insensitive. Click the search icon in the toolbar to expand the search input.
The search is ephemeral: it is not saved with the Mapbook.
Pagination
The table shows 50 rows per page. Use Previous and Next to navigate. The page info shows how many rows match the current filters (e.g., "Showing 1-50 of 243 rows"). Applying or removing a filter resets to page 1.
Synced selection
The map and table selection stay in sync in both directions:
- Click a table row to select it. The map highlights the matching hex cell.
- Click a hex on the map to select it. The table scrolls and paginates to that row.
- Shift+click in either view to add to the selection without clearing it.
- Ctrl+C / Cmd+C copies selected rows as tab-separated values with headers.
Column management
Right-click (or click) any column header to open the column menu:
- Rename the column
- Sort ascending or descending
- Filter (opens the filter editor for that column)
- Pin / Freeze the column so it stays visible when scrolling horizontally
- Hide the column without removing the data
- Remove the column from the Mapbook
You can also toggle column visibility using the Columns dropdown in the toolbar.
Summary row
A sticky summary row at the bottom of the table shows per-column statistics: count, sum, average, min, and max. Click the summary value to cycle through the aggregation types.