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.
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"
The process outlined in Experience League, is not what Adobe documentation has outlined in creating aggregates; following ACS documentation will return errors.