session log analysis

[Anonymous]

hi all

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)

Thanks

[tyagishaila]

Atleast share image of chart/Table which actually you want.

[Anonymous]

hi

thanks for your reply

please find the attached chart for sample

mentioned my comments in red color. please help me to achieve thhis

thanks

[jagan]

Hi,

In script arrive a new column like below and use it as dimension in Pivot table

LOAD

*,

If(SESSION_START >= MonthStart(Today(), -5), MonthName(Today()) & ' to ' & MonthName(Today(), -5),

If(SESSION_START >= MonthStart(Today(), -17), MonthName(Today(), -6) & ' to ' & MonthName(Today(), -17),

'Other'))

FROM ------------

Hope this helps you.

Regards,

jagan.

[tyagishaila]

Jagan's post will help you surely.

try it.. and let us know is it working or not.

Thanks,

[Anonymous]

Hi Thanks alot its working