Last thread entry of oldest email

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