Visual Designer

Summarize

Groups and aggregates rows — SUM, COUNT, AVG, MIN, MAX, and COUNT DISTINCT — to turn raw rows into a business-readable metric.

SummarizeSUM · by Region

What it does

A Summarize node groups rows by a dimension and computes an aggregate measure over them. The node is labeled with the business metric first — the column being aggregated — with the aggregation function and grouping column shown as supporting detail. A workflow computing total revenue by region reads "Revenue — SUM · by Region" directly on the canvas.

What it doesn't do yet

Today, one Summarize node supports one measure and one grouping dimension. Grouping by multiple columns at once, or computing multiple measures in a single node, is on the roadmap.

Common use cases

Total revenue by region or account
Count of orders per customer
Average order value by month

Frequently asked questions

SUM, COUNT, COUNT DISTINCT, AVG, MIN, and MAX.

See the Summarize node in the Visual Designer.