Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Time diffirent between pages in each session

Hi, I have a table like in the picture: In each session, a user visits a few pages How can I calculate the average time between pages in each session? I try: AVG_Time = AVERAGEX( ADD...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Create a new column like

new column =
datediff(maxx(filter(Table, [session_id] = earlier([session_id]) && [page] = earlier([page])), [Date/Time]), [Date/Time], second)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    amitchandak 
    Something is wrong with the code