Group+Aggregate+Column Details

Element Details: Group+Aggregate+Column

Available in: Logi Info

Source code name: GroupAggregateColumn

Setting a Group Aggregate Column adds a column to the DataLayer that represents an aggregated value such as SUM, AVG, MIN, MAX or COUNT. Except for COUNT, MIN, MAX, and CONCAT, the Aggregate Column from the DataLayer must be numeric.

The default DataType is "Number".

ATTRIBUTES

Click attribute Name to drill down for more information.

Name

Possible Values

Description

AggregateColumn

UserDefined

(Required) The column (field name) that is being aggregated. For COUNT, you can specify any column name. Other aggregate functions require a numeric column.

AggregateFunction

Sum

Stdev

Mode

Min

Median

Max

DistinctCount

Count

Concat

Average

(Required) Aggregate function sets the function for the aggregation.

ConcatSeparator

UserDefined

The character used to separate concatenated text values. Defaults to a comma.

DataType

Text

Number

Date

Specifies the type of data present.

UserDefined

(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.

PARENT ELEMENTS

Click element to drill down for more information.

Group Filter

CHILD ELEMENTS

Click element to drill down for more information.