average 
Returns the average of all the values of a column. 

count 
Returns the number of rows in the table containing the column. 

cumulative_average 
Takes a measure and one or more attributes. Returns the average of the measure,
accumulated by the attribute(s) in the order specified. 
 cumulative_average (revenue, order date, state)

cumulative_max 
Takes a measure and one or more attributes. Returns the maximum of the measure,
accumulated by the attribute(s) in the order specified. 
 cumulative_max (revenue, state)

cumulative_min 
Takes a measure and one or more attributes. Returns the minimum of the measure,
accumulated by the attribute(s) in the order specified. 
 cumulative_min (revenue, campaign)

cumulative_sum 
Takes a measure and one or more attributes. Returns the sum of the measure,
accumulated by the attribute(s) in the order specified. 
 cumulative_sum (revenue, order date)

group_average 
Takes a measure and one or more attributes. Returns the average of the measure
grouped by the attribute(s). 
 group_average (revenue, customer region, state)

group_count 
Takes a measure and one or more attributes. Returns the count of the measure
grouped by the attribute(s). 
 group_count (revenue, customer region)

group_max 
Takes a measure and one or more attributes. Returns the maximum of the measure
grouped by the attribute(s). 
 group_max (revenue, customer region)

group_min 
Takes a measure and one or more attributes. Returns the minimum of the measure
grouped by the attribute(s). 
 group_min (revenue, customer region)

group_stddev 
Takes a measure and one or more attributes. Returns the standard deviation of
the measure grouped by the attribute(s). 
 group_stddev (revenue, customer region)

group_sum 
Takes a measure and one or more attributes. Returns the sum of the measure
grouped by the attribute(s). 
 group_sum (revenue, customer region)

group_unique_count 
Takes a measure and one or more attributes. Returns the unique count of the
measure grouped by the attribute(s). 
 group_unique_count (product , supplier)

group_variance 
Takes a measure and one or more attributes. Returns the variance of the measure
grouped by the attribute(s). 
 group_variance (revenue, customer region)

max 
Returns the maximum value of a column. 

min 
Returns the minimum value of a column. 

moving_average 
Takes a measure, two integers to define the window to aggregate over, and one
or more attributes. The window is (current  Num1...Current + Num2) with both end
points being included in the window. For example, "1,1" will have a window size of
3. To define a window that begins before Current, specify a negative number for
Num2. Returns the average of the measure over the given window. The attributes are
the ordering columns used to compute the moving average. 
 moving_average (revenue, 2, 1, customer region)

moving_max 
Takes a measure, two integers to define the window to aggregate over, and one
or more attributes. The window is (current  Num1...Current + Num2) with both end
points being included in the window. For example, "1,1" will have a window size of
3. To define a window that begins before Current, specify a negative number for
Num2. Returns the maximum of the measure over the given window. The attributes are
the ordering columns used to compute the moving maximum. 
 moving_max (complaints, 1, 2, store name)

moving_min 
Takes a measure, two integers to define the window to aggregate over, and one
or more attributes. The window is (current  Num1...Current + Num2) with both end
points being included in the window. For example, "1,1" will have a window size of
3. To define a window that begins before Current, specify a negative number for
Num2. Returns the minimum of the measure over the given window. The attributes are
the ordering columns used to compute the moving minimum. 
 moving_min (defects, 3, 1, product)

moving_sum 
Takes a measure, two integers to define the window to aggregate over, and one
or more attributes. The window is (current  Num1...Current + Num2) with both end
points being included in the window. For example, "1,1" will have a window size of
3. To define a window that begins before Current, specify a negative number for
Num2. Returns the sum of the measure over the given window. The attributes are the
ordering columns used to compute the moving sum. 
 moving_sum (revenue, 1, 1, order date)

stddev 
Returns the standard deviation of all values of a column. 

sum 
Returns the sum of all the values of a column. 

unique count 
Returns the number of unique values of a column. 

variance 
Returns the variance of all the values of a column. 
