Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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:
but this not work (
@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)
User | Count |
---|---|
13 | |
8 | |
8 | |
7 | |
5 |
User | Count |
---|---|
21 | |
15 | |
15 | |
10 | |
7 |