-1

Requirement is to filter for report with multiple complaints for same customer. Added account as grouping by row but unable to filter the group count > 1 kinda of statement. How to achieve this in salesforce reports. I am looking for a simple Group by field having count > 1 sql statement... Unbelievable I have to post such a question as documentation is not available about this functionality. please help.

0

2 Answers 2

1

You can't do this with a report.

Refer the Idea

But you can certainly do this with a query.

Go to the Developer Console, click on the Query Editor tab, and enter the query as follows:

select count(id) CaeCount, accountid Id
from Case 
group by accountid
having count(id) > 1
0
  • Create a custom field Case_Count__c on Account
  • Use DLRS to roll up the Count of Cases to this field
    • Use Calculation Mode = Scheduled to run a one-time job to update all Accounts; then switch to Calculation Mode Realtime
  • Change your report filter to include on Accounts where Case_Count__c > 1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.