Element Details: DsAggregate+Column
 Back


Available in: Logi Info Source code name: DsAggregateColumnIntroduced in: 12.5

DsAggregateColumn adds an aggregate operation to a Dataview for DataLayer.DataServices. It adds a new column representing an aggregate value of all rows.

Set the ID to the name of the new column.

Element Group:Add and Replace Columns



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
AggregateColumn
UserDefined
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
Min
Max
Distinct
Count
Avg
(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.
IncludeCondition
True
False
An expression that evaluates to a value of True or False. If the expression is blank, or evaluates to true the element is processed. If the expression evaluates to false, the element is skipped. Expressions should be in VBScript or JavaScript syntax. For .NET versions, the scripting language can be set in the _settings.lgx General element. For Java versions, the scripting language is always JavaScript. Typically, you would compare values using an operator, such as "@Session.value~ < 0". Use quotes when working with strings: "@Session.myValue~" == "SomeValue"



PARENT ELEMENTS

Click element to drill down for more information.

DataLayer.Data Services DsGroup


CHILD ELEMENTS

Click element to drill down for more information.



 Back to top