Output charts as tables

All chart types now support the drawing of the data as tables using the Draw As property.

The tables drawn are pivot tables that may contain subtotals. This terminology and rules are applied:

  • The columns of the tables are either of type Dimension (the data items that are used to group values ) or of type Value .
  • Values are aggregated or totaled by the Dimension.
  • Dimension columns precede Value columns in the table.
  • The order of the Dimensions specifies the order of the data.
  • Subtotals are generated for each Dimension except the rightmost.

Mapping of chart properties

  • Map chart - the Key property is mapped to a Dimension column, and the Value property to a Value column.
  • Category chart - the Category Key property and the Key property are mapped to Dimension columns, and the Value property to a Value column.
  • XY chart - the Series Title property is mapped to a Dimension column and the X and the Y properties are mapped to Value columns.

There are three types of tables: Table, Sorted table, and Aggregated table.

Table

This option lists all data items in a table. The data needs to be presorted in the order of the dimensions; if this is not the case, the table will contain useless subtotal rows.

If the number of rows in the table is large, then Table is the preferred choice since it produces the tabular output row by row while reading the input and does not keep a copy of the table data in memory. In other words, this option does not delay the output until the end of the input has been read. as the Sorted Table and Aggregated Table options do.

Sorted Table

This option produces the same output as the Table option, but the data does not need to be presorted. The output is delayed until the last row of table data has been read, and the entire table data is stored in main memory.

Aggregated Table

This option draws the same table as the previous two options, but subsequent rows with identical dimensions are drawn only once and the total values are computed. This option always sorts the data, and delays the output until the last row of data has been read. This option is not available for XY Chart types.