Aggregation
An Aggregation node represents a relational group-by and aggregation operation.
Prerequisites
Procedure
- In the General tab, you will see the column information from the previous node. You can add, delete, and rename the columns, as needed.
- (Optional). If you don't see all of the columns from the previous node, or if this node does not have a previous node yet, click the + icon to add rows.
-
Specify the columns that you want to have the aggregate or group-by actions taken upon by
clicking the dropdown list in the Action column.
Option Description Avg Calculates the average of a given set of column values. Count Returns the number of values in a table column. Group-by Use for specifying a list of columns for which you want to combine output. For example, group sales orders by date to find the total sales ordered on a particular date. Max Returns the maximum value from a list. Min Returns the minimum value from a list. Sum Calculates the sum of a given set of values. - (Optional) Select the Filters tab to compare the column name against a constant value. Enter the expression or use the expression editor by dragging the column names, the function, and entering the operators from the pane at the bottom of the screen. For example, if you want to view the number of sales that are greater than 10000, your expression might look like this: "Aggregation1_input"."SALES" > 10000. See the "SQL Functions" topic in the SAP HANA SQL and System Views Reference for more information about each function.
- Click Apply to return to the canvas.
