Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
User | Document | Month | Day | Year | Session Start | Duration | Session End |
Chris | opportunities_projects.qvw | Jan | 4 | 2013 | 2013-01-04 07:57:44 | 00:13:29 | 2013-01-04 08:11:13 |
Brett | opportunities_projects.qvw | Jan | 4 | 2013 | 2013-01-04 08:20:18 | 03:36:52 | 2013-01-04 11:57:10 |
Mike | bookings.qvw | Jan | 4 | 2013 | 2013-01-04 08:32:05 | 00:30:24 | 2013-01-04 09:02:29 |
Christina | opportunities_projects.qvw | Jan | 4 | 2013 | 2013-01-04 08:33:04 | 00:30:42 | 2013-01-04 09:03:46 |
Kelly | cv_customers_people.qvw | Jan | 4 | 2013 | 2013-01-04 09:17:33 | 00:00:40 | 2013-01-04 09:18:13 |
Susan | opportunities_projects.qvw | Jan | 4 | 2013 | 2013-01-04 09:18:16 | 00:04:40 | 2013-01-04 09:22:56 |
Steve | cv_customers_people.qvw | Jan | 4 | 2013 | 2013-01-04 09:18:16 | 00:07:32 | 2013-01-04 09:25:48 |
Susan | opportunities_projects.qvw | Jan | 4 | 2013 | 2013-01-04 09:23:13 | 00:33:37 | 2013-01-04 09:56:50 |
Dennis | site_dashboard_md.qvw | Jan | 4 | 2013 | 2013-01-04 09:44:24 | 00:12:21 | 2013-01-04 09:56:45 |
Susan | opportunities_projects.qvw | Jan | 4 | 2013 | 2013-01-04 09:57:04 | 00:30:11 | 2013-01-04 10:27:15 |
Susan | site_dashboard_md.qvw | Jan | 4 | 2013 | 2013-01-04 09:57:19 | 00:34:31 | 2013-01-04 10:31:50 |
Check the attached qvw.
Though it has a conceptual problem when the session starts in one day and ends in other.
Check the attached qvw.
Though it has a conceptual problem when the session starts in one day and ends in other.
Great Job Fernando!
I'm ok, with the days not taken into account. The server client session will time out long before that would occur. This meets the analysis perfectly.
If I wanted to change it to larger increments i.e. minutes/hrs vs. 30sec. would it still work?
Yes if you change the "sampling" interval it should still work.
Though you must be careful with the time interval not being too distant, as it may not consider a session. For example if you have a session from 00:00:01 to 00:29:59 and your sampling interval is for each 30 minutes, it will not be considered neither in the 00:00:00 and in the next 00:30:00. Hope I made my point clear enough...