5 Replies Latest reply on Jan 9, 2019 12:53 AM by sajad.bhat

    Counting 'Active' Sessions using Start Time and End Time

    Prasana Uthayakumar



      I've spent hours trying to figure this out and I've hit a roadblock. See attached for data of wi-fi sessions. Each internet session has a unique ID, with a start time and end time in the format YYYY-MM-DD HH-MM-SS. What I am trying to work out is how many active Wi-Fi sessions there will be at any given time on any specific day.


      I initially tried to use this article below but it hasn't worked at all (I changed weeks to seconds in the example below)



      Any help would be greatly appreciated! Thank you in advance.