Simple Aggregate Count

[holmes74338504]

I am BEYOND frustrated with ACS. All I want to do is pull the @domain from my recipient table and provide a count. 

I'm pulling a query, adding the @domain as Additional Date. I'm then running the Query into an Enrichment and when I try to take an Aggregate, I get the same message - "Must be GROUP BY". 

HELLO! This function does not exist in the tool. Can someone please help me.

[holmes74338504 · Accepted solution]

I figured it out. I found a post in Experience League that guided me through it. However, this needs to be mentioned in Adobe documentation: 

"Problem with aggregate function in ACS"

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/problem-with-aggregate-func... 

The process outlined in Experience League, is not what Adobe documentation has outlined in creating aggregates; following ACS documentation will return errors.