What's new in Customer Journeys?

Connect and learn more! ×
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
edited May 14, 2018 2:37PM in Reporting & Analytics for B2C Service 3 comments


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,


Service Cloud

Howdy, Stranger!

Log In

To view full details, sign in.


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