Time Difference expression for particular rows

[ankur_abhishek]

Hi,

I want to create an expression to calculate how much time a particular user stay on a specific page.

I have attached a sample file.

i.e I want to know for a particular session id how much time user stay on login page & various other pages in mins .I am not able to achieve this.

Please help me in creating Expression.

Thanks

Ankur

[ankur_abhishek]

Please help me on this?

[antoniotiman]

Hi Ankur,

Dimensions :

user_name

session_id

Expression :

Max({<page_viewed={'Logout Page'}>} page_viewed_datetime)-
Min({<page_viewed={'Login Page'}>} page_viewed_datetime)

Regards,

Antonio

[ankur_abhishek]

Hi Antonio,

Thanks for your reply!

As per your expression, it will so the time diff btw login page & logout page. But I want the time difference btw the first page (e.g login page) user visit than with the second page (e.g landing page) and so on. So that i can calculate the time user stay on a particular page.

Here in data unique session ids are created wrt particular user & remain same until user logout.

[antoniotiman]

See Attachment.

[ankur_abhishek]

Hi Antonio,

Thanks for your reply & great work . But there is an error if I select a page from list box it is showing time as below screen shot marked in red.

[antoniotiman · Accepted solution]

See Attachment.