Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Simple Aggregate Count

holmes74338504
Level 4
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.

Adobe Campaign Standard aggregated metrics count
1 Accepted Solution
holmes74338504
Correct answer by
Level 4
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
holmes74338504
Correct answer by
Level 4
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