Simple Aggregate Count | Community
Skip to main content
H
holmes74338504
Level 3
October 5, 2020
Solved

Simple Aggregate Count

  • October 5, 2020
  • 1 reply
  • 3164 views

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

 

I'm pulling a query, adding the @2977804 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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by holmes74338504

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-function-in-acs/qaq-p/264206 

 

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

 

1 reply

H
holmes74338504AuthorAccepted solution
Level 3
October 6, 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-function-in-acs/qaq-p/264206 

 

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

 

    Terms & ConditionsAccessibility statement

    Loading footer...