4 Replies Latest reply: Jan 13, 2013 9:01 AM by Fernando Suzuki RSS

    Count Concurrent/Overlapping Session Timestamps?

    Brian Garside

      All,

       

      I have a session log flat file with User sessions. I'm looking for overlapping sessions times by distinct users.

      I'm trying to do this at Object or Chart level if possible.

       

      The attached Excel file shows the desired highlighted overlaps. Where my Chart only sees one instance.

       

      My end result would be a chart or column that shows a count for each overlapping session.

       

      UserDocumentMonthDayYearSession StartDurationSession End
      Chrisopportunities_projects.qvwJan420132013-01-04 07:57:4400:13:292013-01-04 08:11:13
      Brettopportunities_projects.qvwJan420132013-01-04 08:20:1803:36:522013-01-04 11:57:10
      Mikebookings.qvwJan420132013-01-04 08:32:0500:30:242013-01-04 09:02:29
      Christinaopportunities_projects.qvwJan420132013-01-04 08:33:0400:30:422013-01-04 09:03:46
      Kellycv_customers_people.qvwJan420132013-01-04 09:17:3300:00:402013-01-04 09:18:13
      Susanopportunities_projects.qvwJan420132013-01-04 09:18:1600:04:402013-01-04 09:22:56
      Stevecv_customers_people.qvwJan420132013-01-04 09:18:1600:07:322013-01-04 09:25:48
      Susanopportunities_projects.qvwJan420132013-01-04 09:23:1300:33:372013-01-04 09:56:50
      Dennissite_dashboard_md.qvwJan420132013-01-04 09:44:2400:12:212013-01-04 09:56:45
      Susanopportunities_projects.qvwJan420132013-01-04 09:57:0400:30:112013-01-04 10:27:15
      Susansite_dashboard_md.qvwJan420132013-01-04 09:57:1900:34:312013-01-04 10:31:50

       

      Chart For Log.png