The DsAggregate Column

The DsAggregate Column element is used with DataLayer.Data Services to add a new column to the data containing an aggregated value of the data in one of the other columns.

The following topics discuss the DsAggregate Column elements:

• DsAggregate Column Attributes
• DsAggregate Column Usage Example

For more information about Dataviews, see Dataviews.

About the DsAggregate Column

The DsAggregate Column element discussed here is available in Logi Info v12.5 but has been deprecated in later Info versions; consult the Release Notes for specific details.

The DsAggregate Column is similar to other elements designed to extend the available data. Like the DsCalculated Column element, it's added as a child element beneath DataLayer.Data Services and adds a new column to the data. This column contains derived data which is accessible using an @Data token.

The new column's value is the result of aggregating the value of the data in one column, for all rows, in the data. The aggregated value is populated in the new column in every row of the data so that it can be used in further calculations and displays.

Similar aggregations can be performed in a Dataview definition but this element allows dynamic aggregations based on variable conditions at runtime.