Last thread entry of oldest email
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,