
e.g.
If Owner 1 has 20 Leads, of which there are 15 unique companies, the total would be 15.
If Owner 2 has 50 Leads, of which there are 5 unique companies, the total would be 5.
The report would show the totals for Owner 1 and Owner 2, preferably with a list of Leads grouped by company.
The dashboard componant will show Owner 1 and Owner 2 on an axis, and the charted totals would be 15 and 5, resspectively,
I've tried the "Rule of 1" method, but can't seem to achieve the results. If anyone has any specific suggestions around that method, I'll certainly reevaluate.
Any help is greatly appreciated!
1 risposta
Josh - You will need to create a way to find the "Unique Company" and create a report as follows:
First....
Create a summary report.
Create a field possibly call it "CompanyKey".
This should be a Formula Field of type Text. The forumlua should be a string that identifys that particular Company.
For example, my LeadKey Formula is: FirstName & LastName & Phone
Summarize the report by CompanyKey (mine is summarized by LeadKey)
Add a formula called "dupCnt"
Set up your report to Group by your CompanyKey and use the "Power of 1"
(See the "The "Power of One" technique" by Steve Molis) (https://success.salesforce.com/_ui/core/chatter/groups/GroupProfilePage?g=0F9300000001pFV&fId=0D53000001GwrJW)
https://success.salesforce.com/_ui/core/chatter/groups/GroupProfilePage?g=0F9300000001pFV&fId=0D53000001GwrJW
Let me now if you need any more assistance!
Praise to the POWER OF ONE the DemiGod of Analytics Tom Tobin!!