2 Replies Latest reply on Dec 2, 2018 7:31 PM by Zhouyi Zhang

    Unable to get require field

    Calvin Pinto

      Hi All,

       

      I want to do the particular calculation for the GOR ID, for the particular Activity field with respective minimum/maximum time (24hr format hh: mm)  for the minimum time I want to get respective GOR ID as well for the maximum time I want to get their respective GOR ID.

       

      For Example

      I have attached the sample table as well as the screenshot has been appended, Let me know how it can be resolved. Thanks in advance.

          

      Day of Create_ActualActivityGor IdTime
      28-11-2018deliveredGRH1260477012:47
      GRH4286098312:42
      GRH4360728717:41
      GRH8383145612:48
      delivery_failedGRH4894566815:10
      dispatchedGRH2579078315:46
      GRH4360728710:56
      GRH5673148415:14
      GRH9074803415:14
      pickup_failedGRH2390634715:11
      GRH2738109815:11
      GRH7528770315:12
      GRH8382886815:12
      pickup_request_deliveredGRH3057448516:58
      GRH7428980616:58
      pickup_scheduledGRH2250550014:00
      replacement_pickup_doneGRH2615248012:10
      reverse_delivery_doneGRH7533901216:42