I would like to track on how many Calls and Email Sent/Received on Case.We have enabled email 2 case and sending emails using Send an Email button(Emails related list) on Case and Logging calls from Log a Call button(Activity History) on Case.
Now I would like to report on Number of Calls/Emails made on each case
Created a custom pick list field 'Activity Type' with Call and Email as pick list options.
Created a workflow rule to update Activity Type with Call if subject of Task contains 'Call' and
Created a workflow rule to update Activity Type with'Email' if subject of Task starts with Email
I would like to run report off of Activity Type field
But second workflow is not working as expected as it doesn't update Activity Type to email.I tried by changing the workflow rule criteria from Starts with to Contains
Is my approach correct ?