What I need help with is to determine the first time a member (Assigned to) of that Assignment group responded to that Incident.
On the second screenshot of the attachment you can see we have 2 [Incident Metric Value],Paul McGinnis and Andrew Boyd. Paul McGinnis and Andrew Boyd are both members (Assigned to) of the Assignment group OPS-Windows-Server. But Paul McGinnis responded to the call first at 2016-07-12 13:40:53, but as he is also a member of the Assignment groupPS-TCS-Print my logic is not picking his start time up, but it is picking up 2016-07-14 12:51:02for [Incident Metric Value]Andrew Boyd. Please see my logic below.
Does anyone know of a way that I can use the above logic for the Official_Start_Timeto also find the first (Assigned to) of the Assignment group OPS-Windows-Server. To give me Paul McGinnis response time of 2016-07-12 13:40:53.
Any help would be appreciated. I hope this makes sense to someone, I think I have waffled on a bit