Tables in EasyMap

Properties

The Properties command can be used to change column settings for the current table. Here you can remove columns from the view by removing the checkmark in front of the respective column. You can also adjust the order of the columns individually by using the two arrow keys; a multiselection with the Ctrl key is possible.

Via the button Rename you can change the display name of the column in the EasyMap. This also works for linked tables, the descriptions are not written back to the linked original application file.
For columns of numbers, you can also change the Format for the display in the table and map (e.g. number of decimal places, currency and percentage). The accuracy of the original data is not changed by this setting. It is not possible to turn a number into a key or a text.
Click Display to change the color and font of a column in the table. You can change the appearance of the data cells and the header line separately.
In the Display area on the right, you can select between Data value, Bars with data value (in relation to the other cells in this column) and Bars without data value for columns of the data type Number. Bars for positive numbers are drawn in blue and bars for negative numbers in red and cannot be changed individually. For columns with the data type Text you can choose between Data value or Color.
In the Statistics area, you will find an informative overview of statistical key figures for the selected column.

Note:

The representations set here are also used for table objects and for data display in EasyMap Xplorer.
When displaying the column as a color, it is important that the selected column already has a color value.
As a rule, the color values for result tables or tables of the area structure can be converted so that they display the column with HTML color values as a color field or as a value - for example, or #33CCCC.

Edit Query

With Queries you can compile data from one or more tables.

Copy selection to clipboard

This allows you to copy your selection to the clipboard. If you hold down the Shift key while clicking on the symbol, all values with formatting will be copied to the clipboard.

Filter options

Edit filter	Here you can see whether a filter is active. Another click on the button allows you to extend the filter. Then the window "Filter table" will be opened to edit the filter criteria. In the dialog window Filter table you are able to compile your own criteria for the filter. All calculation rules for the calculated columns are available here. Note: The filter expression must return True or False as the result - e.g. [columnA]="Cologne". Always use a point as decimal separator, no comma (i.e. 2.5).
Remove filter	Cancels the filter settings.
Previous Filter	Adjusts the last set filter.
Filter modified	This filter can only be found for tables that are created in the territory organization (in the DistrictManager Edition). If changes are made in the territory organization, you can use this filter to display the changes. Filter Last Changed shows you only the records that were affected by the last change.
Filter by selection	Only useful if a coupling to a level is available. When activated: This filter only shows records of elements that are marked in the map window. The corresponding areas are determined based on links.
Filter by clip map	Only useful if a coupling to a level is available. Falls Enabled: The table displays only records for elements that are visible according to the clip map. The corresponding areas are determined via the coupling. In addition, the pop-up area can be used to influence the layer used: Automatic: The standard logic of the coupling is used. If there are several couplings, EasyMap selects a suitable level for the coupling. Setting a specific layer: The clip map of this layer is used for the filter.
Apply filter to analysis	Determines whether a filter should also affect analyses and table objects. Activated: The filter is also applied to analyses and table objects so that they only show partial results. Individual analyses can be excluded by selecting Ignore filter from the analysis context menu. Deactivated: Analyses and table objects always work on the entire table. If a filter is set, this only affects the display within the table window. Note: If you set the classification of your analysis to User-Defined, the classification settings for each value class are retained, even if some classes are omitted by a filter.

Show Sum

The symbol button Show Sum displays a row at the top of the table containing the total of the respective column. The sum is only calculated for columns that are formatted as numbers. If the command is executed again, the row is hidden again. (available in the context menu of External Data, Queries, Geographic Data, and Analysis Results)

Connect Table and Map

Coupling a table and a map results in a mouse click in the map marking the corresponding rows in the coupled table, while a mouse click in the table marks the corresponding object in the coupled map.

Further information and instructions on how to pair data with the map can be found here - Couple table and map.

Zoom to marker

If there is a marker in the table (whether one row or more), this marker can be displayed in the map. If you click on the Zoom button on Marked, the map zooms exactly into the area.

Add Column

This function allows you to add your own calculated columns. Settings and possibilities of the calculations can be found here.

Tables in EasyMap

Additional filter and sort options in the tables