You need to sign in to do that
Don't have an account?
hy.lim1.3897974166558203E12
Create custom column in report based on row calculation in Matrix Report
Hi I have a custom report (Activities with Case) created like this ->
Now I would like to add an additional column and value would be 'Email - Received' - 'Email - Sent'. Possible to do that?
Now I would like to add an additional column and value would be 'Email - Received' - 'Email - Sent'. Possible to do that?
Emails sent/recieved are stored in the email related list and the read/sent is stored under a SINGLE field which is "Status" you can run the report using Case with Email report type and pull up the report in the following format:
Case Owner/ Account Name /Subject/Date/Time /Opened Age (Hours) /Open/ Closed/ Email/ Subject Email /Status
I did not use email in my case, I uses activity history (created from Email to Salesforce) instead, the report is based on activity history. I just want to add an additional column that the value are substraction from the other 2 columns.
https://success.salesforce.com/answers?id=90630000000gxiDAAQ
And one more thing is how can i get the avg date time (highlighted in brown) of each record like show in sample pic below:
If yes than please share here .I am having the same problem now.
Thank you