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

      Hi,

       

      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)

      https://kb.tableau.com/articles/howto/showing-records-that-fall-within-a-period-of-time

       

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