7 Replies Latest reply on Feb 7, 2019 9:36 AM by Aleksandr Sanchez

    How to flag encounters using two criteria in the data?

    Tony Fahd

      Hi, so I am attaching a workbook where I have a city field, my customer ID, From date,Todate, Period and service.I want to flag all customer IDs that had a Broken car in the Post period and the From date of the broken car is within 2 days of Todate of the initial Trigger.

       

      so for example customer ID A1 had a broken car in the post period that falls within 2 days of the Todate of the Trigger (in this case, it's the Car service that happened on 1/12018 through 1/3/2018)

       

      Any help is appreciated.