Average based on calculated aggr value

[martin_hamilton]

Hi

I am looking to calculate an average page view per session for a web application.

I have managed to use an aggr expression in a table to calculate the unique page views per Session but now want to calculate the average unique page across all sessions loaded into qv.

Attached is a sample qv file with data loaded inline and where I have got to so far.

What i wanted to do was use count the distinct session IDs and divide by the total amount of unique pages to gain an average.

Any help appreciated.

Thanks

Martin

[sunny_talwar · Accepted solution]

Do you expect 7.4? May be this

=Avg(Aggr(Count(Distinct PAGE),SESSION_ID))

[martin_hamilton]

Thanks Sunny that worked a treat.