Forum Discussion

cheid_4838's avatar
cheid_4838
Helper IV
2 years ago

Drive Duration Calculation

I am probably making this harder than it needs to be, but I am trying to calculate the driving time between each stop sequence for each order.  For example for stop 2 for order 6005581 I need to know...
Need Help
  • cheid_4838's avatar
    cheid_4838
    Helper IV
    2 years ago

    Thanks for the quick response and your help.  I think I understand what you provided, but have a couple of questions.

     

    1.  What value would I put between the brackets in this statement?   VAR __Current = [Value]

    2.  Since I have multiple orders, how do I make sure that the driver duration is only calculated within each order and that the time won't be calculated across orders like the example I provided where there were two orders?   

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      2 years ago

      cheid_4838 Since you want to subtract the previous departure time from the current arrival time, then you would put VAR __Current = [Arrival Date & Time].

       

      You will want to capture the current driver and perhaps order similar to the __Current variable. You then need to use those when filtering to find your previous row.

      • cheid_4838's avatar
        cheid_4838
        Helper IV
        2 years ago

        I must be missing something because I keep getting a syntax error message.  What am I missing?  

         

        Table = stops

         

        Drive Duration =

        VAR CURRENT = stops[stp_arrivaldate]

        VAR PreviousDate = MAXX(FILTER(stops,stops[stp_departuredate] < EARLIER(stops[stp_departuredate]

        VAR Previous = MAXX(FILTER(stops,stops[stp_departuredate]= PreviousDate,stops[stp_arrivaldate])

        RETURN
        (_Current - _Previous)*1