Average of session actions

[#1]

Hi everyone,

I have a problem with creating an average amount of actions done in sessions.

I want to be able to see the average amount of actions done in 1 session.
I´m loading data into my qvw from Qlikview Logfiles. Those logfiles contain sessions wich are used to determine

a time when somedone done something in qlikview.

I tried to use a function where I used "sum(count(Message))/count(Session_key)

The message counts the amount of things someone does during a session.
The Session_key is a primary key generated for every single session. In this way, all sessions are unique.

The function I tried to use didn't work because of a syntax error I think. And if I just use the

"count(Message)/count(Session_key)" function, then this will appear as average.

I don't think this number is the right average of things someone does in one session.

Is there anyone who might know a solution to this?

Thanks in advance,

Ivo

[sunny_talwar · Accepted solution]

May be this:

Avg(Aggr(Count(Message), Session_Key, Product))

[#3]

That was very quick and very helpful!
Thanks!!

[sunny_talwar]

It was just a random guess