trying to get session duration. but im not getting it properly plz refer 'session duration(In Sec.)' column. if my 'no.of session' is more than 1 then i have to get total session duration for that user. Please advise.
Expressions used in below chart:
No. Of Session =COUNT(SESSION_START)
Session Duration (In Sec.)=(SESSION_DURATION)
you could use an aggregation function like avg:
that would be at least arithmetically correct.
Other thing would be, if you have a Session_End field you could calculate sum(Session_End - Session_End)
if you have a unique ID for each session put this in your dimension.
session duration is directly coming from session log file. if i am using Sum(SESSION_DURATION) is not giving correct result. so in script i am doing SESSION_DURATION * 86400 AS Ses_dur_in_sec, and doing in expression sum(Ses_dur_in_sec) then coming correct.
any idea how i can get this without doing it in seconds.
both giving me same answer anyways that seconds is ok.
but now i need to show this in 1 to 6 months and 7 to 12 months columns, as i am not very sure in interval match for months. is it possible to help me on this please