Expand my Community achievements bar.

SOLVED

Simple Aggregate Count

Avatar

Level 4

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.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 4

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. 

 

View solution in original post

1 Reply

Avatar

Correct answer by
Level 4

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.