A sales rep typically has several open opportunities for each of their accounts. Which tool should a Platform Administrator suggest to the sales rep to obtain the total number of accounts associated with open opportunities in a report?
When a report contains many rows where the same Account name appears multiple times (due to having several opportunities), a simple count of rows will not accurately represent the number of distinct accounts. To find the specific number of individual accounts, the Platform Administrator should use the Unique Count feature on the Account Name or Account ID column in the report builder. Selecting " Show Unique Count " provides a total at the bottom of the report (and in summary groupings) that counts each unique value only once, regardless of how many times it appears in the list. Bucket Columns (Option A) group data into categories46. Report Filters (Option B) exclude records47. Grouping Rows (Option D) visually organizes the report by Account but does not inherently provide a single summary number for the count of distinct accounts in the way that Unique Count does.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit