<< Click to Display Table of Contents >> Aggregate |
Aggregate is to perform data aggregation operation group by Group Columns. Set Group Columns to "MARKET" and Aggregate Columns to "PROFIT", as shown in the following figure.
[Data Columns] Display all the visible column of the input node.
[Group Columns] The columns are using for grouping which can be empty. The left column can be dragged to Group Columns.
[Aggregate Columns] The columns are used for aggregation operation which can be null. The left column can be dragged to the aggregate column
[Type] Types of aggregate function.
The calculation results are shown in the figure below: