+ Start a Discussion
tbuckettbucket 

Users WITHOUT New Activities, New Accounts. New Contacts, etc

We are building some adoption and usage dashboards, and we have the standard/popular dashboard items such as: New Accounts Created By User, New Contacts Created By User, Closed Activities, etc.  The requirement is to show ALL Users, not just users with records in these dashboard items.  So basically we want the zero's to show up.  Also, we want to use on a dashboard with filters on it.

 

Long ago, I started creating a number field strictly for reporting, and setting the default value to "1", then report off of that field instead of the record count field.  This seems to work in most, if not all scenarios, but is a little bit of a pain to set up between the custom report type for each object were reporting on, plus creating the custom field, then back-filling existing records via data loader.  

 

WIth improvements in reporting and analytics, does anyone have a better method to do what I am trying to do.

 

Thanks in advance!