Help center Get started Knowledge center Product documentation API documentation
Product
Lens Weave Maskbits
Overview
Data
Data Import Output Result
Data Preparation
Cleansing Imputation Duplicates Filter Fuzzy Filter Outlier Treatment Binning Trimming Validation Sorting
Transformation
Data Transformation Bulk Data Transformation Merge Union Fuzzy Merge Encoding Normalization Scaling Standardization Aggregate Unpivot Functional Transformation SQL Executor
Statistical Plots
Box Plot Correlation Histogram Pair Wise Line Plot Scatter Plot Bar Plot Stem Plot Step Plot Fill Between Stack Plot Descriptive Statistics
Workflow Agent
Workflow Agent
Scheduler
Scheduler
Library
My Workflows Shared Workflows Audit
Datasource
Datasource
Datasource Management
Data Model
Connectors Management
Admin
Admin
User Management Roles Management Group Management Organization Management

Overview

The Aggregate node is a transformation node in a Weave Workflow that groups a table by selected columns and returns aggregated output columns. It sits in the middle of a Workflow’s processing path between source nodes (Data Import) and terminal nodes (Result, Output) and emits the aggregated data downstream.

Configuration has three parts: Aggregation Criteria defines the group-by columns; Output defines the columns for the final result, each paired with an aggregate function from a dropdown; and Filter Output optionally filters the aggregated rows and columns. The output columns are named with their function (for example, avg_Units_Sold).

Note: “Workflow” is the in-UI term for what some Weave documentation calls a pipeline. This reference uses “Workflow.”

When to use it

  • Summarizing row-level data into grouped totals, averages, or extremes.
  • Producing per-group metrics (for example, average units sold and maximum sales per group).
  • Reducing a detailed table to one row per group for reporting or downstream processing.
  • Filtering aggregated results to groups that meet a condition via Filter Output.

Configuration components

ComponentDescription
Aggregation CriteriaGroups the table by the selected column(s). Opened via Select.
OutputChooses the columns for the final output along with their aggregation function from a dropdown. Opened via Select.
Filter OutputFilters specific rows and columns out of the aggregated data. Opened via Filter.

Aggregate functions

The Output dialog assigns one of the following functions to each selected column:

FunctionDescription
CountReturns the number of elements in a column.
FirstReturns the first non-null element in a column.
LastReturns the last non-null element in a column.
MeanReturns the average of values in the input column.
MaxReturns the maximum value in a column.
MinReturns the minimum value in a column.
StdReturns the standard deviation of a numerical column.
VarReturns the variance of a numerical column.
SumReturns the total of a numerical column.

Filter Output reference

The Filter Criteria dialog defines conditions on the aggregated data as rows, optionally organized into groups.

FieldDescription
ColumnThe column the filter applies to.
Aggregate FunctionThe aggregate function evaluated for the condition.
Filter ConditionThe comparison applied (e.g. equals, greater than).
InputThe value compared against.
ActionAdd (+) a criteria row; Add Group / Delete Group manage groups.

Key behaviors

Aggregate is a transformation node. Unlike Data Import (source) and Result / Output (terminal), it sits in the middle of the Workflow, receiving data upstream, grouping and aggregating it, and passing the result downstream.

Grouping drives row count. The result has one row per unique combination of the Aggregation Criteria columns. The Output columns are computed within each group.

Function per output column. Each Output column carries its own aggregate function chosen from the dropdown, and the result column is named accordingly.

Optional post-aggregation filter. Filter Output applies after aggregation, removing rows and columns that do not meet the criteria.