Simple Aggregate Count

Avatar

Avatar
Validate 10
Level 3
holmes74338504
Level 3

Likes

17 likes

Total Posts

51 posts

Correct reply

5 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
holmes74338504
Level 3

Likes

17 likes

Total Posts

51 posts

Correct reply

5 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
holmes74338504
Level 3

05-10-2020

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.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 10
Level 3
holmes74338504
Level 3

Likes

17 likes

Total Posts

51 posts

Correct reply

5 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
holmes74338504
Level 3

Likes

17 likes

Total Posts

51 posts

Correct reply

5 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
holmes74338504
Level 3

06-10-2020

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. 

 

Answers (0)