The two(2) fields that can be compared are the Completed Date field of a Phone Call record
Here are the steps on how to create the saved search: 1. Create a Customer saved search via Lists > Search > Saved Searches > New 3. Enter a Search Title. 4. On the Results tab, add the following fields, with the corresponding Summary Type, Function
a) Name where Summary Type = Group b) Date Created where Summary Type = Group c) Formula (Date/Time) where Summary Type = Minimum
Formula={call.completeddate} Summary Label = 1st Phone Call Completed Date Function = Number as Time Summary Label = Difference bet 1st Call from Lead's Created Date NOTE-- To display the time period on a per day basis, set up the Function field to blank Formula=TRUNC((min({call.completeddate}))-{datecreated}),0) |
No comments:
Post a Comment