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)
Last updated