Pivot Table

The pivot table is an analytic component which allows the user to generate custom reports from a dataset, and play with those data in several ways.

\

Esqueleto de XML

To define a pivot table in AWE you must follow the next structure:

<pivot-table id="pivotTableId" target-action="getDataOfPivotTable" max="0" style="expand"/>

Attributes

Atributo	Version	Uso	Tipo	Descripción	Valores
id	3.0	Required	String	Grid identifier. Con fines de referencia
style	3.0	Opcional	String	Clases CSS de Grid
carga-inicial	3.0	Opcional	String	Llamada de acción del servidor para cargar los datos de la cuadrícula. It only supports query value
server-action	3.0	Opcional	String	Llamada de acción del servidor	See server action list
target-action	3.0	Opcional	String	Destino para llamar al servidor
max	3.0	Opcional	Entero	Maximum number of elements to retrieve per page
ayuda	3.0	Opcional	String	Texto de ayuda para la cuadrícula	Note: You can use i18n files (locales)
imagen de ayuda	3.0	Opcional	String	Imagen de ayuda para la cuadrícula	This must be a image path
total-row-placement	New from 3.1	Opcional	String	Place the totalizer row	top, bottom. Default value is bottom
total-column-placement	New from 3.1	Opcional	String	Place the totalizer column	left, right. Default value is right
renderer	New from 3.1	Opcional	String	Initially selected renderer	Table, Table Barchart, Heatmap, Row Heatmap, Col Heatmap. Default value is Table
aggregator	New from 3.1	Opcional	String	Initially selected aggregator	Count, Count Unique Values, List Unique Values, Sum, Integer Sum, Average, Minimum, Maximum, Sum over Sum, 80% Upper Bound, 80% Lower Bound, Sum as Fraction of Total, Sum as Fraction of Rows, Sum as Fraction of Columns, Count as Fraction of Total, Count as Fraction of Rows, Count as Fraction of Columns, Custom aggregators. Default value is null
aggregation-value	New from 3.1	Opcional	String	Initially selected aggregation column	A column from the initial column list. Default value is null
sort-method	New from 3.1	Opcional	String	Value sort method	absolute (absolute value sort), natural (natural sort). Default value is natural
rows	New from 3.1	Opcional	String	Initially selected rows	Add more than one separated by commas
cols	New from 3.1	Opcional	String	Initially selected columns	Add more than one separated by commas
decimal-numbers	New from 3.1	Opcional	String	Number of decimals	Note: You have to set a custom aggregator like Custom sum, Custom Average, Custom Minimum, ...
thousand-separator	New from 3.1	Opcional	String	Thousand character separator	Note: You have to set a custom aggregator. Default value is '.'
decimal-separator	New from 3.1	Opcional	String	Decimal character separator	Note: You have to set a custom aggregator. Default value is ','