Get Column Stats

Calculates an aggregate value of a table column.

Overview

This procedure is used to calculate an aggregate value for a table column. It can be used to apply a function to a column and get its sum, mean, average, count, minimum, maximum, standard deviation, or sample variance.

Input Concepts

Concept	Type	Description	Default	Required
column	table's column	The column to perform the aggregation on.	No default	Yes
aggregate function	string	The function to use for aggregation. Valid options are: sum, mean, average, count, min, max, median, std, var.	No default	Yes

Output Concepts

Concept	Description
aggregate value	The result of the aggregation.

Examples

In the following examples, the column refers to the Amt column in the table below.

Amt	Min	Max
100	10	30
200	5	500

Note: This sample table can be generated using the create an integer table procedure.

1. Get the Column Count

Automation

get the column's count

Results

2

2. Get the Column Average

Automation

get the column's average

Results

150.0

3. Get the Column's Maximum

Automation

get the column's max

Results

200