Saltar al contenido principal
Version: 4.3.0

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.

PivotTable

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

AtributoVersionUsoTipoDescripciónValores
id3.0ObligatorioStringGrid identifier. Con fines de referencia
style3.0OpcionalStringClases CSS de Grid
carga-inicial3.0OpcionalStringLlamada de acción del servidor para cargar los datos de la cuadrícula. Sólo soporta el valor de consulta
server-action3.0OpcionalStringLlamada de acción del servidorVer lista de acciones del servidor
target-action3.0OpcionalStringDestino para llamar al servidor
max3.0OpcionalEnteroNúmero máximo de elementos a recuperar por página
ayuda3.0OpcionalStringTexto de ayuda para la cuadrículaNote: You can use i18n files (locales)
imagen de ayuda3.0OpcionalStringImagen de ayuda para la cuadrículaEsta debe ser una ruta de imagen
total-row-placementNew from 3.1OpcionalStringPlace the totalizer rowtop, bottom. Default value is bottom
total-column-placementNew from 3.1OpcionalStringPlace the totalizer columnleft, right. Default value is right
rendererNew from 3.1OpcionalStringInitially selected rendererTable, Table Barchart, Heatmap, Row Heatmap, Col Heatmap. Default value is Table
aggregatorNew from 3.1OpcionalStringInitially selected aggregatorCount, 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-valueNew from 3.1OpcionalStringInitially selected aggregation columnA column from the initial column list. Default value is null
sort-methodNew from 3.1OpcionalStringValue sort methodabsolute (absolute value sort), natural (natural sort). Default value is natural
rowsNew from 3.1OpcionalStringInitially selected rowsAdd more than one separated by commas
colsNew from 3.1OpcionalStringInitially selected columnsAdd more than one separated by commas
decimal-numbersNew from 3.1OpcionalStringNumber of decimalsNote: You have to set a custom aggregator like Custom sum, Custom Average, Custom Minimum, ...
thousand-separatorNew from 3.1OpcionalStringThousand character separatorNote: You have to set a custom aggregator. Default value is '.'
decimal-separatorNew from 3.1OpcionalStringDecimal character separatorNote: You have to set a custom aggregator. Default value is ','