Math & Statistics icon

Math & Statistics

Calculate safe allowlisted math and statistics operations for finance datasets.

Actions8

Group Aggregate → Group Aggregate

AI-generated

Summary

Aggregate rows by a specified group column and compute one or more aggregations (Count, Sum, Mean, Min, Max) on a numeric value column for each group.

Inputs

  • aggregations (required) — Select one or more aggregations to compute for each group. If any aggregation other than Count is selected, a Value Column is required.
  • groupColumn (required) — Name of the column to group rows by before aggregation.
  • valueColumn — Name of the numeric column to aggregate. Required unless only Count aggregation is selected.

Output shape

a single JSON object summarizing aggregated data per group

Returns an object containing the group column name, optional value column name, list of selected aggregations, total number of groups, count of ignored non-numeric values, and an array of group aggregation entries. Each group entry includes the group value, row count, counts of valid and ignored values, and computed aggregation results as requested. The output is sorted by the group value string. If non-numeric values are present in the value column, a warning is included indicating those were ignored.

Examples

Example 1: Grouping sales data by region with sum and count aggregations

Set Group Column to 'region', Value Column to 'sales', Aggregations to ['sum','count'] and execute the operation to get total sales and row counts per region.

Links

Discussion