ET1’s Group By Overview

by | Sep 10, 2025 | App Documentation

Eager to group data?

The Group By feature can be found in the Aggregation Node.

Add the aggregation node to the canvas and send data downstream to this node.

We have many products, however duplicate quantities across many suppliers, and we need to check the quantity of entire business!

Product,Quantity
Widget A,93
Gadget B,20
Tool C,122
Device D,4
Accessory E,300
Widget A,120
Gadget B,60
Tool C,180
Device D,30
Accessory E,250

Using Group By in ET1

Open your Aggregation Node.

Aggregation node is automatically set to record count, and requires some setting changes to begin grouping data.

  1. Set the group by column
  2. Set the column you want to measure
  3. Set the operation, like sum, avg, mean, count..

How we use Group By

Grouping data is helpful when you need to consolidate records based on repetitive groups or classifications of your information.

In this data source above we need to measure by quantity!

So, let’s begin by choosing the Group By as Product.

Operation, SUM! We want to Sum the Quantity.

Questions? Please contact us.

Return to ET1 Overview to learn more.