aggregate Field

Causes the grid to calculate aggregate values on the column and place them in the column footer cell or group header and footer rows. Possible values are: "none", "count", "sum", "average", "min", "max", "std", "stdPop", "var", "varPop" and "custom".

Syntax

Javascript (Usage)
var instance; // Type: wijmo.grid.IC1BandOptions; var value; // Type: string value = instance.aggregate;

Javascript (Usage)

var instance; // Type: wijmo.grid.IC1BandOptions;
var value; // Type: string
value = instance.aggregate;

Javascript (Specification)
var aggregate : string;

Example

Javascript

$("#element").wijgrid({ columns: [{ aggregate: "count" }]});

Remarks

Possible values are: "none": no aggregate is calculated or displayed. "count": count of non-empty values. "sum": sum of numerical values. "average": average of the numerical values. "min": minimum value (numerical, string, or date). "max": maximum value (numerical, string, or date). "std": standard deviation (using formula for Sample, n-1). "stdPop": standard deviation (using formula for Population, n). "var": variance (using formula for Sample, n-1). "varPop": variance (using formula for Population, n). "custom": custom value (causing grid to throw groupAggregate event). If the showFooter option is off or grid does not contain any groups, setting the "aggregate" option has no effect.

Browser Compatibility

See Also

Reference