Table of Contents |
---|
Info |
---|
...
The following instructions refer to the Dataset detail page |
Data visualisation
Click on Table tab to visualise the data with a table:
...
Info |
---|
There are some technical limitations in the Table visualisation:
If one tries to overtake this limit, an error message will be displayed. This limitation adds up to the interactivity limit (see this page) |
Special values and Flags
Under the table, the following items are always displayed:
Special values. Special values are values that can be present in the data cells. They do not represent statistical data, but they replace them. Existing special values are the following:
":": When the colon is present, it means that there is no data available in this cell. For example:
In this example, no data is available for Belgium in 2017.
Flags. Flags are metadata which provide additional information about a specific statistical data. When present, this additional information is required for a correct interpretation of the data. For example:
In this example, the statistical data of Spain on 2018 (15 852.53) should be considered as provisional (because of the "(p)" flag).
...
Info |
---|
Flags can be combined: In this example, the statistical data for European Union in 2017 (154 792.75) should be interpreted as being estimated and provisional altogether. |
Anchor | ||||
---|---|---|---|---|
|
Click on Format tab to set the different format options of the table.
...
Info |
---|
Labelling options, Decimal symbol options and Thousands symbol options are described on this page. |
Anchor | ||||
---|---|---|---|---|
|
Show (default value): Available flags are shown in brackets after the figure they are referring to. The legend is available at the bottom of the table.
Hide: Flags are hidden.
Anchor | ||||
---|---|---|---|---|
|
Show (default value): The empty rows are displayed
Hide: The empty rows are hidden
...
Info |
---|
If one or more row/column is masked using this option, an orange exclamation mark () appears at the top right of the table. When clicking on this button, a modal appears, showing the list of currently hidden elements: |
Anchor | ||||
---|---|---|---|---|
|
Show (default value): The empty columns are displayed
Hide: The empty columns are hidden
...
Info |
---|
If one or more row/column is masked using this option, an orange exclamation mark () appears at the top right of the table. When clicking on this button, a modal appears, showing the list of currently hidden elements: |
Anchor | ||||
---|---|---|---|---|
|
...
Right (default value): Statistical data is aligned on the right of each cell:
Decimal separator: Statistical data is aligned on the decimal separator:
Anchor | ||||
---|---|---|---|---|
|
...
When displaying such dataset in a Table, the serie attribute will be visible as an additional column, at the extreme right of the screen. Example with a TARGET serie attribute:
Anchor | ||||
---|---|---|---|---|
|
...
In order to add/remove positions to the table while in this mode, an additional menu is required. This menu is activated by clicking on the brush icon (
). It renders a list showing to the user the current selection of positions. The ones currently highlighted and thus visible in the table are in bold. A position can be added/removed by clicking on its item in the list....
In case the table is accessed while there are no highlighted positions, the following rules will apply to ensure a baseline table is rendered:
...
Tip |
---|
|
It is also possible to manage which positions are highlighted and which are not by using the dimension dropdowns (see this page for more information).
Summary
...
When the Summary mode is activated, the result is the following:
The amount of positions selected in the “Selection” tab does not change. However, only the rows corresponding to the "Top 8 - Middle 8 - Bottom 8" rule exposed above will be displayed. All the other rows are masked.
A warning message is also displayed above the table (orange background). When clicking on it, or when clicking on the button, modal will be displayed, listing all the positions for which no row is currently displayed because of the Summary mode.
...
Position the cursor of the mouse on any boundary of the columns headings to make the resize icon appear.
Move the boundary to adjust the column width.
Double click on the boundary to minimise the column width.
Click on the title of the dimension in Row to change the sorting of the positions. Available sorting orders are:
Default sorting order, represented by (for example, the default sorting order for the GEO dimension is the Protocol order)
Descending (9→0) / Reversed alphabetical (Z → A) sorting order, represented by (appears on the extreme right of the header of the dimension in Row)
Ascending (0→9) / Alphabetical (A→Z) sorting order, represented by (appears on the extreme right of the header of the dimension in Row)
Click on the header of any column to sort all the displayed data on the basis of the data contained in this column. Available sorting orders are:
No sorting based on this column (default situation)
Descending (9→0) sorting order, represented by (appears next to the title of the column)
Ascending (0→9) sorting order, represented by (appears next to the title of the column)
NoteInfo Please notice that, when sorting, an absence of value (represented by ":") is considered as a value greater than any other value
Highlight options
In the Table visualisation, it is possible to use the highlight feature (see this page)
How do the highlighted positions appear in Table?
Example:
How do I change the highlight of a position?
...
Info |
---|
It is only possible to highlight rows. Highlighting column positions is not possible. |
To highlight a position, double-click on the gray cell header at the left of the row.
...