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

    How many by hour - using only starting & ending timestamps


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

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






      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.



      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...