Identify INC status considering max date

[sriku]

Hi All,

I need a help in identify the incident status considering the max date for each incident and solve the below queries:

Question 1: For each incident I need to flag as "Untouched" and " touched", if max date of each Inc is "Assigned"

Question 2: Once identified as "Untouched" I need to idenified immediate status of Assigned for each Inc (Max endate of each incident) and flag as 1( "Immediate status" and 0 ("Not Immmediate")

Question 3: Need to indenify how many cases are "resolved" immediately before "Assigned" considering max date of start date

Question 4:  Once identified as "resolved" need to calculate how many times that particular incident is falled under resolved

Attached is the data for reference.

Thanks in advance

Regards,

Srikant

[DavidP · Accepted solution]

How about this?

[sriku]

Thanks David, It work