AggregateColumnModel API in JavaScript TreeGrid API control

Interface for a class AggregateColumn

Properties

columnName

string

Specifies the column name to display the aggregate value. If not defined, the field name is used by default.

customAggregate

CustomSummaryType | string

Defines a custom function to calculate the aggregate value. The type must be set to custom. Use the custom value as ${custom} in templates.

• Total aggregation: The custom function is called with the entire dataset and the current AggregateColumn object.
• Group aggregation: It is called with the current group details and the AggregateColumn object.

field

string

Specifies the column name on which to perform the aggregation.

footerTemplate

string | Function

Defines a template for the footer cell of the aggregate column. Use the aggregate type names within the template to access aggregate values.

format

string | NumberFormatOptions | DateFormatOptions

Specifies the format to be applied to the calculated aggregate value before display. Supports both standard and custom formats for numbers and dates. Refer to the Syncfusion documentation for number and date formats.

type

AggregateType | AggregateType[] | string

Defines the aggregate type(s) for a particular column. To apply multiple aggregates to a single column, specify the type as an array. Available aggregate types include:

• sum: Calculates the sum of all values in a column.
• average: Computes the average of the column values.
• max: Finds the maximum value in a column.
• min: Finds the minimum value in a column.
• count: Counts the number of records.
• falsecount: Counts the number of false values.
• truecount: Counts the number of true values.
• custom: Allows for a custom aggregate function. Use custom to specify a custom aggregation.