6 Replies Latest reply on Apr 3, 2018 9:20 AM by Emanual Henry

    How many by hour - using only starting & ending timestamps

    bill.merlavage

      Does anyone have any thoughts on how to accomplish something like this?

      Here's my source data format (Name, start time, stop time)

       

       

       

       

       

      EmployeeClock-InClock-out
      Joe Smith8:00 AM5:00 PM
      Tom Jones7:00 AM3:00 PM
      Jim Clark9:00 AM12:00 PM

       

       

       

       

      My end result would be to have a graph that looks like this, showing how many employees were logged-in each hour.

      desired_output.png

       

      I'm not exactly sure whether there's a calculation that I could use to create my axis or whether I'd need to bring in some type of additional data source?  I'm open to any suggestions.

      Thanks in advance...

      Bill