Report Assistance - Aggregation?

MStritt
Tera Guru

I've created a report that shows the amount of Contacts registered/created yesterday on Accounts. It's group by Account. What I want to do, is to only show Accounts where 5 or more Contacts were registered/created on yesterday. 

1 ACCEPTED SOLUTION

James Chun
Kilo Patron

Hi @MStritt,

 

Try the following:

JamesChun_0-1719043114137.png

  • Table: Account [customer_account]
  • Condition: Created on Yesterday
  • Related List Conditions:
    • Greater than or Equal to 5
    • Contact->Account

Cheers

View solution in original post

2 REPLIES 2

James Chun
Kilo Patron

Hi @MStritt,

 

Try the following:

JamesChun_0-1719043114137.png

  • Table: Account [customer_account]
  • Condition: Created on Yesterday
  • Related List Conditions:
    • Greater than or Equal to 5
    • Contact->Account

Cheers

Got it. Thanks!