Element Details: Sql+Aggregate+Column
 Back


Available in: Logi Info Source code name: SqlAggregateColumn

ActiveSQL SqlAggregateColumn adds a new column in the DataLayer that represents an aggregate value of all rows of the DataLayer.

The column can be used like any other column. The value is populated in every row so that it can be used in further calculations, SummaryRows, LinkParams, etc. It is also populated in the top-level row, allowing reference to the value anywhere in the report outside of a DataTable.

Set the ID to the name of the new column.

Set the AggregateFunction attribute to the type of aggregate desired, Sum, Count, Average, Min, or Max.

The column data type must be numeric for the Sum, Count, and Average functions.

Element Group:Add and Replace Columns



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
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
Min
Max
DistinctCount
Count
Average
(Required) Aggregate function sets the function for the aggregation.
ID
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.

DataLayer.ActiveSQL Sql Group Sql Query


CHILD ELEMENTS

Click element to drill down for more information.



 Back to top