Using Aggregates on a Event in AJO | Community
Skip to main content
Level 4
January 22, 2026
Question

Using Aggregates on a Event in AJO

  • January 22, 2026
  • 1 reply
  • 25 views

Hello, 

 

I need some help. I’m trying to use the aggregate function to create an audience. My criteria is: 

  • Transacation Date >10 days from Current Date
  • Specific currencyID codes AND Amount Value = 1

The profile can have up to 5 currency ID’s. I’m trying to create an audience that when I sum up the Amount, I only select those where total is <=4. 

I keep getting profiles where the amount is 5. I’m at a loss because this aggregate is not doing what I assume is should be doing. Any assistance would be appreciated. 

1 reply

SatheeskannaK
Community Advisor
Community Advisor
January 22, 2026

@montezh2001 Can you post the screenshot of the audience setup?

Thanks, Sathees
Level 4
January 23, 2026

Here you go. I’ve tried it a couple of different ways. 

And I’ve tried it this way as well: