Report row summary percentage of total record count? - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Jaime OrtegaJaime Ortega 

Report row summary percentage of total record count?

I have a field that calculates the number of days from a submitted date to the date the user says it's needed. I built a matrix report that reports the various answers. The header values represent the number of days and the cells the record counts: See below:
User-added image
What I need is to be able to show the percentage of the record count for each header value against the total row record count. So, for example, the record count for column 0 is 1 and the total number of records for that row is 9. So the 0 column % is 1 / 9 or 11.11%. There' will be mutiple users, so I need to show the percentage for just their total records, not the grand total of all users. Now it gets a little trickier. 0 represent them asking for a quote the same day they request, 1 is needing it within 24 hours and 2 withing 48 hours. Anything beyond 2 (ex. 3, 5, 9, 60 days) can be added together. Not the number of days, but the record count of records with numbers exceeding 2. So the total for the example above would be 4. I'm assuming I'd have to have formula columns for each category, but not sure. Here is the manual spreadsheet that they currently use:
User-added image
The name of the custom field is Days_from_Submitted_to_Needed__c
Can anyone help me out?

















 
Best Answer chosen by Jaime Ortega
Steve MolisSteve Molis
Okay, in that case I would use a Report Bucket and grouped them accordingly

All Answers

Steve MolisSteve Molis
Are you looking for something like this?
1
User-added image
2
User-added image
Jaime OrtegaJaime Ortega
Hey Report Guru,

I see your name quite a bit on report questions. Yes, that's basically what I need, but a couple of things. One, I'm not real clear about the whole PARENTGROUPVAL thing. The second would be, I need the Yes, Of Course and Obviously totals and %s separate, but Hell Yeah, Most Certainly and Damn right you do would represent anything beyond 2 days and should be combined for percentages. Which is why I was thinking formula columns to the right of the Grand Total column. I inderstand there could be multiple columns to the left (1, 5 6, 7 25, 57, 100 whatever) but to the right are just a 4 that represent same day, 1 day, 2 days and then everything greater than 2 combined. using some type of formula. Possible?
Steve MolisSteve Molis
Where are those Hours Fields in your Report?  Are you just "bucketing" the Days from Submitted Field in your first screenshot?
Jaime OrtegaJaime Ortega
Yep, it's all from a single field: Days_from_Submitted_to_Needed__c. It's a field that calculates the number of days between two dates. That's why I was saying there could be 30 different answers, so for percentages I just combine record counts for anything beyond 2 days. as single percentage, as illustrated in the spreadsheet above.
 
Steve MolisSteve Molis
Okay, in that case I would use a Report Bucket and grouped them accordingly
This was selected as the best answer
Jaime OrtegaJaime Ortega
That did it! Thanks Sensei.
 
Jaime OrtegaJaime Ortega
Hey Steve, I'm hitting a wall here. I have the report working using buckets with each bucket having the appropriate header name, but can't figure out how to get the % of each compared to the Grand Total for the row:

User-added image
The name of the field these values are coming from is Days_from_Submitted_to_Needed__c
Will this not work with buckets?
Monica PortilloMonica Portillo
Hey Jaime - Did you get a response from your latest post?