Calculate Last Assigned to first Changed Status

Content

Looking at the inc_performance.intv_type I only can find the "Last Assigned to Final Resolve". But not Last Assigned to Status changed.

I like to calculate the time when the Incident is "Last assigned" to the first date the Status is changed.

Have someone experience with this?

I tried something like this, but that is not working.

IF(if(transactions.trans_type.id=6,transactions.created)>if(transactions.trans_type.id=4,max(transactions.created)),transactions.created)

For example: Looking at the Image below like to have the difference between Last Assigned (24/08/2016 12.55 PM) and  Changed Status (25/08/2016 08.00 AM)

Version

February 2016