AggregateColumnModel

12 Sep 20251 minute to read

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.