aggregate Option

Default value: 'none'

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)
$(function () { // Get value var returnsValue; // Type: string returnsValue = $(".selector").c1field("option", "aggregate"); // Set value var newValue; // Type: string $(".selector").c1field("option", "aggregate", newValue); });

Javascript (Usage)

$(function () {
    
    // Get value
    var returnsValue; // Type:  string
    returnsValue = $(".selector").c1field("option", "aggregate");
    
    // Set value
    var newValue; // Type:  string
    $(".selector").c1field("option", "aggregate", newValue);
        
});

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