Crosstab display shows the output data in a two-dimensional table, using one output field defined to produce the (horizontal) columns and a set of fields to produce the row keys of the matrix.

The cell value is given by the definition of the general table output columns (or an n-tuple if it is a list).

• These fields let you reformat the output data according to masks compatible with the “sprintf” function.

Learn more about formatted strings

Documentation on output data configuration

• For a list of reference fields, the format list must contain the same number of formatting expressions separated by semicolons. An empty expression means “no formatting”.

Example: For a query defining an attendance rate, you may want to format the division (float) as a number with one digit after the decimal point.

• The “data output” and “output format” fields, for example, would be expressed like this:

mois;ratio
;%.1f

• If defined, the different values of this data series will separate the results into different tables. Note that for the split to take place and for subtotals to appear, the table must be sorted on the splitting column.

• Horizontal: When enabled, each row (resp. column) will have an additional column (resp. row) giving the numeric sum of the row (resp. column). Note that if cells display a tuple, only the first field is summed.
• Vertical: When enabled, each row (resp. column) will have an additional column (resp. row) giving the numeric sum of the row (resp. column). Note that if cells display a tuple, only the first field is summed.

• Vertical series label: Titling of your choice, separated by ;
• Horizontal series label: Titling of your choice

• Valéry Frémaux (valery@activeprolearn.com)- Development and documentation
• Florence Labord (florence@activeprolearn.com) - documentation

Back to the configuration guide index - Back to the component index - Go to the generic query catalog - Back to the plugin index - Back to the catalog