Skip to main content
Blog

ET1 Group By Overview

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...

· Dev3lop Team

{/* Content imported from WordPress - review and enhance */}

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.

  • Set the group by column

  • Set the column you want to measure

  • 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.

← All posts