Identify INC status considering max date

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

Example.xlsx

Datasets

Date Time

Accepted answers

DavidP

You can use the summarize tool to find the max (end) date for each incident and join it back to the dataset. From here you can work out the logic for the other fields.

This will get you started. Feel free to post again when you run get stuck.

Inc status.yxmd

DavidP

How about this?

Inc status.yxmd

All comments

DavidP

You can use the summarize tool to find the max (end) date for each incident and join it back to the dataset. From here you can work out the logic for the other fields.

This will get you started. Feel free to post again when you run get stuck.

Inc status.yxmd

sriku

Hi David,

Thanks for your response.

I can able to find the max date using join and idenfity. But when I flag to know the immediate status of "Assign" my logic is not working properly and it picked other rows.

Regards,

Srikant

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703