Aggregate Column Usage Example

The following example, which provides a count of all customers, illustrates how the Aggregate Column works:

In the definition shown above, a data table and a datalayer element have been added. An Aggregate Column element has been added and its attributes have been configured so that it will count the number of customer IDs in the data retrieved into the datalayer.

The resulting count will be placed in a new column, named agrCustCount, in every row of the datalayer, and will be accessible as the token @Data.agrCustCount~. Because the value is in every row, it's available for use with every row of data in the table.