3 Replies Latest reply on Jul 10, 2018 11:36 PM by Mavis Liu

    Flag start/end times per day

    Matthew McGrath

      Hi,

       

      I have a data set with multiple GPS devices that record multiple trip information every day. I want to be able to identify the  first start and last end time for each day by device.

       

      I want to make histograms showing the start and times using different device groupings.

       

      Data kind of looks like this:

       

      Device IDStartEnd
      A2018-07-10 7:00 AM2018-07-10 8:00 AM
      A2018-07-10 9:00 AM2018-07-10 4:00 PM
      A2018-07-11 7:00 AM2018-07-11 12:00 PM
      B2018-07-10 7:00 AM
      2018-07-10 8:00 AM
      B2018-07-10 9:00 AM2018-07-10 4:00 PM
      C2018-07-10 7:00 AM2018-07-10 4:00 PM
      C2018-07-11 7:00 AM2018-07-11 4:00 PM

       

      Thanks in advance

       

      Matt