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(
ADDCOLUMNS(
FILTER(
SUMMARIZE(
FactEvents,
'FactEvents'[Date/Time],
FactEvents[SESSION_ID],
FactEvents[Page]
),
'FactEvents'[SESSION_ID]=max('FactEvents'[SESSION_ID]) && 'FactEvents'[Date/Time]<=MAX('FactEvents'[Date/Time])&& 'FactEvents'[Page]=MAX('FactEvents'[Page])
),
"diff",DATEDIFF(MIN('FactEvents'[Date/Time]),MAX('FactEvents'[Date/Time]),MINUTE)
),
[diff]
)
 

but this not work (

 

 
 

 

 

 

 

 

2 Replies

  • 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)