+ Start a Discussion
ErinKErinK 

Total Usage Score

I've built a dashboard of 6 tables that rank each sales person by the number of contacts, accounts, opps, leads, tasks and events they have created since a specified date. Our sales manager now would like to be able to give each sales person an overall score  or weighted average based on the total records created for each object.

 

Does anyone have any idea on how this could be done? Any suggestions would help! Thanks!