Skip to main content
I am trying to create a report and dashboard componant that displays the total number of unique companies within a list of leads, displayed by owner.

 

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 resposta
  1. 9 de jul. de 2015, 17:09
    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)

     

    Josh - You will need to create a way to find the

     

    Add a formula called "dupCnt"

     

    User-added image

     

    User-added image

     

    Set up your report to Group by your CompanyKey and use the "Power of 1" 

     

    User-added image

     

    (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!!