Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Last thread entry of oldest email — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Last thread entry of oldest email

Accepted answer
17
Views
3
Comments
edited May 14, 2018 2:37PM in Reporting & Analytics for B2C Service 3 comments

Content

Hi all,

In our reporting we use a calculated column for the last thread entry of an incident [max(threads.entered)].

We currently have a report which displays the most recent update of the oldest unresolved email in each queue:

[min(if(incidents.status_type <> 2, incidents.updated))]

I'd like to show this but using the date of the last email sent or received for the incident instead of the last update but I can't seem to figure it out.

Any help would be much appreciated,

Version

Service Cloud

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!