event occurence
1 Topic
Check event occurred within set time of previous event of same unique ID
I have a list with unique system ID's who require periodic Preventive Maintenance. I would like to know whether for that same system ID there has been a Corrective Maintenance within one month after the Preventive Maintenance. So in the example table below, I would like to identify the case types in red, those are corrective maintenance cases that occured within a month after a preventive maintenance. How do I make this identification? System ID Case Type Date 1 Preventive Maintenance 01/Jan/24 2 Preventive Maintenance 01/Jan/24 3 Preventive Maintenance 01/Feb/24 4 Preventive Maintenance 01/Feb/24 1 Corrective Maintenance 25/Jan/24 5 Preventive Maintenance 01/Mar/24 6 Preventive Maintenance 01/Apr/24 2 Corrective Maintenance 02/Feb/24 3 Corrective Maintenance 17/Feb/24 7 Preventive Maintenance 01/Apr/24 8 Preventive Maintenance 01/May/24 9 Preventive Maintenance 01/May/24 5 Corrective Maintenance 02/Jun/24 6 Corrective Maintenance 08/Apr/24 6 Corrective Maintenance 12/Jun/24Solved1.1KViews0likes7Comments