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
