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

    Flag start/end times per day

    Matthew McGrath



      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