Group By

Groups values together based on a chosen method. Think Sumifs, Averageif, ect.

Function:

GroupBy(table = string, value = string, cols = list, method = drop down, new_table_name = string)

Parameters:

Table: Table name on which to perform function

Value: Column with Values you wish to evaluate

Columns to Group: Columns that you wish to Group

Method: How to aggregate the data (sum, count, mean, min, max, median)

New Table Name: Name for new grouped table

Examples:

GroupBy(table = Budget, value = Amount, cols = [geo, business_unit], method = sum, new_table_name = Budget_Grouped)