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. | |