Report Option for Distinct/Unique Records - Ideas - Salesforce Trailblazer Community
Trailblazer Community

All Ideas

Idea Details

Post an Idea
This idea has been delivered and can no longer be voted or commented on. If you’d like to add to this conversation, please post a new idea.
19,510  Points voting closed
Delivered in Spring 20
Delivered in Spring 20

Report Option for Distinct/Unique Records

Operational Reporting

It would be great to have the option on custom reports to specify that the results should show only one instance of a record, even if that record appears multiple times within the report. For example, I would like a report that shows me all accounts that have at least one "Closed Won" opportunity, and even if the account has more than one Closed Won opportunity, the account name would show once. This will allow me to see how many unique accounts that I have that have purchased something. Another example would be for an Opportunities with Products report: The report would show a list of unique opportunities that have product x or product y attached. This concept is similar to the "SELECT DISTINCT" concept in SOQL.

· Flag

Latest Comment from Salesforce

  • Anusha Surepeddi - 1 year ago

    @Drew - In the Prioritization Survey when voting on this idea, I explained that we are inspired by this idea and we will be delivering a unique row count only for Lightning reports. Note that with the Spring'20 GA release of unique row count, you can also use unique row count in a custom summary formula. Showing unique records will not be possible in the lightning report builder since creating such a filter would cause performance/scale issue, so its not something we can deliver successfully. 

    Release notes for Unique Row Count GA (general avaliability) can be found here:
  • Upvotes
  • Downvotes



from AppExchange

Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.

Salesforce takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.