I want to create a report that not only gives me the percentages of missing data on my contacts, but also gives me information on which accounts have no contact at all.
I have part of this question answered - I have the percentage of missing data of certain fields, I created IF(BLANK) fields on the contact so I can pull that record count. However, if an account doesn't have ANY contacts at all - how do I report on this? I created a custom report type so it pulls all the records, and the accounts with no contacts show up as "-" but I can't report on this. What can I do so I can create something that would count "no contact" as a 1? Or a check box on the account that auto populate with a "no contact" or something similar? Any help would be SUPERB. Thank you!
9 respostas
Yeah, you should be able to do that (you gotta keep in mind, this is my Dev org, not your's so I can't have those custom fields on mine).
All I did was use Tom Tobin's "Power of One" technique to get the count of unique Accounts and Contacts, then I added a Report Bucket and Bucketed it by the Count of Contacts
Tips & Tricks: "The Power of One" the Greatest Formula Ever Written*
https://success.salesforce.com/answers?id=9063000000048RbAAI
