I am struggeling a litte bit with the seconddiff functions.
Use Case: I have session data and I want to know the time difference between the end of the first session and the beginning of the second session. Right now I am using this :
SecondDiff([sessionstoptime],[sessionstarttime]) , it parses and gives me data but I am not sure if it is correct.
How do I make sure it gives me the difference between the stop and start of the consecutive sessions and not the difference between them for one session?
Do I need to group it by user?
|User||Session ID||Session Start||Session Stop|
Please sign in to leave a comment.