Report: Percentage of Accounts contacted this week - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Travis GrothausTravis Grothaus 

Report: Percentage of Accounts contacted this week

Hello and happy monday :)
I'm looking to create a "Percentage of Accounts Contacted this last week" report in the simplest way, but I'm not too familiar with creating percents like this.  I'm thinking by starting with an Account report showing all accounts and maybe creating a bucket for last activity date to show if its within a week, but how would I divide that by the total record count?
Best Answer chosen by Travis Grothaus
Steve MolisSteve Molis
Which Edition of Salesforce are you using?  Report Buckets are available in Enterprise or above 

Categorize Data with Bucket Columns
https://help.salesforce.com/articleView?id=reports_bucketing_overview.htm&type=5 (https://help.salesforce.com/articleView?id=reports_bucketing_overview.htm&type=5)

All Answers

Steve MolisSteve Molis
Can you post a screenshot of the Report, Settings, and Filters that you're using, the results you're getting, and a mock-up of what you want?  For questions related to Reports and Dashboards those are really helpful  

if you're using Account Last Activity Date you might wanna create a custom Formula(Number) field on the Account object like this
 
BLANKVALUE( LastActivityDate , DATEVALUE( CreatedDate ) )  - TODAY()
Then use that as your Report Bucket
 
Travis GrothausTravis Grothaus
Hi Steve!
Looking good so far, is there a reason why I wouldn't be able to bucket this new Formula(Number) field?User-added imageUser-added image​​​​​​​
Steve MolisSteve Molis
Whopps!  I had it backwards you need to subtract the earlier date from the later date 
 
TODAY() - BLANKVALUE( LastActivityDate , DATEVALUE( CreatedDate ) )

 
Travis GrothausTravis Grothaus
Thanks for the update! The days are now positive, I'm still unsure why I can bucket by any field, though? Unless you have a better recommendation as to how i can turn this into a dashboard component which shows "% contacted in the last week"?
User-added image
Steve MolisSteve Molis
Did you create a Report Bucket using the new Formula(Number) field that you just created?
Travis GrothausTravis Grothaus
I think I'm missing something extremely basic here but I simply cannot figure it out, when you say create a report bucket, wouldn't there be an option for that when I click the drop down arrow next to a column? Or when I click the arrow next to the "Add a Column"? Unless I'm missing a first step here.User-added image
Steve MolisSteve Molis
Which Edition of Salesforce are you using?  Report Buckets are available in Enterprise or above 

Categorize Data with Bucket Columns
https://help.salesforce.com/articleView?id=reports_bucketing_overview.htm&type=5 (https://help.salesforce.com/articleView?id=reports_bucketing_overview.htm&type=5)
This was selected as the best answer