I have a use case to count all the recipient in database in ACS and print it over the email .
But i am not able to do it using count aggregate function in addtional data as it is giving the error , to group by .
But there is no group by option in ACS ,is there a way we can complete this usecase.
Hi follow given steps:
1. add a false collection to your base query using additional data.
2. add enrichment to compute your aggregates:
3. in your enrichment go to Advanced Relations tab and add a relation to your collected added in the previous query using the @collectionLink as the source and destination expression.
4. Using additional data in enrichment add your aggregates:
now you can use this CountRecords in your email using personalisation field.