I am creating a report in Salesforce using the Cases with Emails standard report. I am trying to get a count of how many emails are sent by each CSA. Because the standard report only allows you to see the Case owner, we cannot pull a report showing how many emails each CSA has sent. It only allows me to tie in the the Case owner for any outbound Emails that are sent out. However when I go into the outbound email message details in Salesforce As you can see from the attached screen shot, it does store who sent the email which is independent of the case owner. My question is, how do I pull a report and include the field created by for that specific email?
The goal of this report is to get a total count of outbound emails by CSA, where the CSA is not always the Case Owner*