Use the data panel

The Data panel helps you gain insights into the relationship between the data and its geography by displaying thematic data.

     The Data panel helps you gain insights into the relationship between the data and its geography by displaying thematic data.

     This is the Data panel icon: 

data-tab

     The panel's tab indicates the total number of features of the current layer between parenthesis.

data-table

     The data panel is configured in this way:
          - interactivity,
          - filter,
          - data settings.

     Interactivity

  • When displaying numeric thematic data, bar charts are included in each row to help view and compare values in the data set. If a thematic analysis is currently displayed on the map, the colour used in the bar charts of the corresponding thematic data column are the same as the colours used in the legend.
  • When mousing over a row, the corresponding map feature is highlighted on the map.
  • You can click on a row to select it. The row will be highlighted in the data panel, the corresponding map feature will be highlighted on the map and that row will be added to the Selection panel. Note that you can perform multiple selections using the SHIFT or CTRL keys.
  • Double-click on a row to zoom to the feature on the map.
  • To sort rows in alphabetic or numeric order, click on the column title.
  • To reorder columns, click on the column title and drag to the new location.
  • To resize a column, click on the border of the column and drag to the desired width.
  • You can also Filter the rows on any data column to display only a subset of data.

     Tools

Icons Description
layer-drop-down Select the layer from the drop-down for which to view the data.
copy-to-clipboard

Copy data to the clipboard.

statistics

Show or hide the data statistics.

remove-filters-data Clear all filters for the current layer.
export

Export the data to a Microsoft Excel Spreadsheet. You need to specify a file as the output.

settings Access the Data Settings.

     Statistics

The statistics Statistics button allows you to switch between the table view and the statistics view. The statistics view summarizes the individual records from the table view. Filters and selections are taken into account in the statistics view.

Each line of the statistic view is a statistical aggregation method. Aggregation methods are written under the first column. Each data column value is then summarized using each method.

statistics-view

There are 936 postal codes selected in this example. The population sum is 3,871,865. The density mean is 310.08.

     Paging

Icons Description
first-page

Go to the first page.

previous-page

Go to the previous page.

current-page (missing or bad snippet)
more-pages

See more pages.

next-page

Go to the next page.

last-page Go to the last page.

     Filter

     The Filter option is used to display a subset of the data on the map, as well as in the Data panel, Chart and Legend.

filtre-870x599

     The Filter tools are:

Icons Description
filter

No activated filter.

filter-activated

Activated filter.

filter Activate a filter.
clear Clear a filter.
remove-filters-data Remove all filters from the current layer.

     Filter by check box

You can check each value individually when there are 50 different values or less in a string thematic data or 10 different values or less in a numeric thematic data.

filter-list

     Filter by a logical expression

Logical expressions are used to filter values when there are more than 50 different values in a string thematic data or more than 10 different values in a numeric thematic data.

String thematic data

The logical expressions available to filter text values are:

filter-text-expressions

For example, you can filter the features whose name contain the word "Mary":

filter-text-example

     Numeric thematic data

     The logical expressions available to filter numeric values are:

filter-text-expressions

     For example, you can filter the features whose Area column is between 50.00 and 99.99 square km:

filter-numeric-example

     Multiple filters

     Note that it is also possible to apply filters on multiple columns as well as on multiple layers to perform more targeted analysis.

filter-example-data

     Data Settings

     The Data Settings is used to change the list of thematic data displayed in the Data panel.

settings

The Data settings are:

Icons Description
data

Select each thematic data individually using the checkboxes.

automatic-data

Select one of the following automatic data options.

none

Remove all thematic data.

active-themes

Display only the data that is the subject of an active thematic analysis on the map.

all-data-active-tables

Display all the data classified in the same data table as the subject of an active thematic analysis on the map.

back-to-table

Exit the settings menu.

cancel

Cancel the changes.

ok Accept the changes.