How to define an aggregation in ACS custom resource. Is it only by linking with N collection cardinality?
For example: if a profile has shipping address as an aggregation with address fields .
You can perform aggregate in Query, as shown below:
Add Group by line and you will be able to execute query without error.