Column reports

In the column report, the displayed analyses are varied by using alternating data columns as a basis. This way you can create time series as reports. If, for example, sales figures for different years are available in separate data columns, the map time series of sales per year can be produced as a column report. EasyMap then generates a map for each year of the time series showing the sales for that year.

Column selection

If you want to create a column report, first define the columns that the report should run through. Simply select the corresponding table and place the checkmarks in front of one or more column names. A multiselection with pressed STRG key is possible here to check several columns at the same time.

Click on the button at the bottom of the dialog box to set the Data type of the report column. As Data type the data type of the selected columns should generally be used. If the columns used have mixed data types, we recommend the data type Text for the report column. If the selected columns are of different data types, the system tries to convert the entries of the iterated column to the specified data type. If the conversion is not possible (for example, a text that does not represent a number and data type Number is used), these entries are ignored.

The figure above shows the settings for a column report on the data columns with the sales of the last four quarters. This report provides a separate sales display for each quarter, i.e. a total map time series with four pages.

analysis selection

In the next step, EasyMap offers the selection of the analyses that are to be included in the report. All analyses that evaluate at least one of the data columns that are the subject of the column report appear in the selection list. If you do not select at least one analysis for the report, the report generates several pages, but each page displays the same view. After clicking on Complete EasyMap creates a new column (the column report column) in the table that the user has selected for the column report. All analyses that the user has selected for the changeover are automatically converted to this column.

The Column Report Column

This column contains the name of the report just created (e.g. "Column report 1") as column header. If the column report has not yet been started, the report column is preset with the values of a data column from the column report (for example, "Total sales"). If you did not select an analysis when you created the column report, the report column contains a collection of mixed values from the selected data columns. These contain, for example, the smallest and largest occurring value of all columns. This allows classifications to be calculated that fit all participating data columns.

If the report is executed (e.g. printed, exported or the report preview is displayed), EasyMap copies the data from the data columns contained in the report into the column report column one after the other and thus creates the changing map displays. If the report is terminated, the column returns to the original values (for example, from the "Total sales" column or mixed values).

The context menu command "'Edit column report'" can also be used outside a report to change the display to a certain other data column. You can access this command in the table by right-clicking on any cell in the column report column.

Output Details

If the option Uniform classes=yes is selected under Output details, EasyMap takes into account all data of all selected data columns (and not only the data of the column used as the basis for a specific report page) for each individual map when calculating the classes used in analyses. If Uniform classes=No is selected, EasyMap only considers the data of the column used for the respective report page for each individual map when calculating the classes used in analyses. The Uniform classes option is only relevant for automatic classifications (e.g. Equal distributed). It has no meaning for user-defined classes.

Add or Remove Analysis to a Column Report

If you insert an analysis on the map after you have created the column report, you can immediately create the analysis based on the column report column. Existing analyses can be switched to the column report column via Properties of the analysis.

To remove an analysis from a column report and thus obtain the same analysis results on each report page, open the Properties of the analysis and select a different column than the column report column.

Note: The result of the analysis can change if you change the analyses. The analyses may then only show the desired result during report output.