Results page

The results page in SOTKAnet is where you can examine your search results, which you have narrowed down either on the search page or with permanent links. You can switch to view the results either as tables, graphics or maps. Data can be displayed graphically (graphs and maps) when a single indicator is used in the search (on the search page or by selecting a single indicator on the results page). Results can also be saved in Excel or CSV format.

The results page is accessible for a limited time and only from the same browser with which the results were accessed. You can create a permanent link to the results page if you want to share the results with someone else, for example. When you access a results page via a permalink, the page is displayed exactly as it was at the time the permalink was created.

Table view

The table view displays the results in table format. You can modify the structure of the table and the order of the variables by clicking on the appropriate icons.

Order of variables

While in table view, you can rearrange the variables by clicking on the icons provided.

	Transposes the variables in the first row and the first column		Transposes the variables in the second row and the second column
	Transposes the variables in the second row and the first column		Transposes the variables in the second and third column
	Transposes the variables in the third row and the first column		Transposes the variables in the first row and the third column
	Transposes the variables in the first and second column		Transposes the variables in the first and second row
	Transposes the variables in the first and third column		Transposes the variables in the first and third row
	Transposes the variables in the first row and the second column		Transposes the variables in the second and third row

The order of the variables can be restored by clicking on the icon "Restore table". Please note that this will also restore the table to its original form.

Restore table

Table form

While in table view, you can modify the structure of the table.

Table with multiple indicators		Table with a single indicator
	Shows three variables in rows and one in a column		Shows two variables in rows and one in a column
	Shows two variables in rows and two in columns		Shows one variable in a row and two in columns
	Shows one variable in a row and three in columns

The table form can be restored by clicking on the icon "Restore table". Please note that this will also restore the order of the variables.

Absolute numbers

You can also choose to view indicator values in numerical form (if this data is available).

Show absolute numbers

Show relative proportion

Highlighting values using background colours

One option when viewing table data is to switch on background shading. This uses different colour tones to represent different municipalities. The values in the tables are marked with different colours according to a 20-60-20 division: the highest 20% of the numerical or percentage values are marked by the darkest tone, the next 60% are shaded in a mid-tone, and the lowest 20% are marked by the lightest tone.

Use background colours

Use no backgroud colours

Results page for a single indicator

If you include multiple indicators in your search, you can also choose to view the tables one indicator at a time. You can switch to view an individual indicator’s results table by clicking on the indicator name. You can then also switch to view any other individual indicators by selecting the indicator from the "Change indicator" list and by clicking on the "Change indicator" button.

Go back to viewing multiple indicators

Saving results

Results tables can be saved in Excel or CSV format.

Export to Excel

Export to csv-file

A results table saved in Excel format is saved as identical as possible to the table shown in your browser. Values are shown either as numerical values or as primary values depending on the selection made on the results page. To make the results easier to process, area codes and indicator IDs are added to the Excel file as separate columns or rows.

Make sure that your results table does not exceed the maximum file size in Excel. Excel cannot process more than 256 columns, for example. If your table is too large for Excel, the system will not display the "Export to Excel" icon.

In CSV format, results will be shown on rows, with the following columns:

1. Indicator name
2. Indicator number (ID)
3. Area name
4. Area code
5. Sex
6. Year
7. Primary value
8. Numerical value

Permanent links

You can create a permanent link to results by clicking on the "Create permalink" button provided. The created permalink replaces the button you clicked. You can copy the permalink and use it later for creating a results page. When you access a results page via a permalink, the page is displayed exactly as it was at the time the permalink was created.