Group Data

Enables selection of column(s) upon which to group by and create new aggregate column(s). The results will output the selected column(s) upon which the data is grouped upon and the aggregated column(s).

The aggregated column can be aggregated based on;

• Count

• Count Distinct

• Average

• Sum

• Median

• Minimum

• Maximum

• Standard Deviation (Entire Population)

• Variance (Partial Sampling)

• Variance (Entire Population)

• First Value (Ascending)

• First Value (Descending)

• Last Value (Ascending)

• Last Value (Descending)