Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
avg(Session_Duration) * count(distinct upper(Authenticated_User))
I'm using the above expression to calculate home many minutes a user is using QlikView. The Avg(Session _Duration is fine, it's when I multiply it by the number of users it gets messed up. I have 500 users using it on avg of 10:05 minutes.
Thanks
In what way is you calculation need up?
Is it an formatting error or is the calculation off?
Try to forget your expression as an interval.
Interval (avg(Session_Duration) * count(distinct upper(Authenticated_User)))
Okay. Here is the example: I have 506 users which use QV on an average of 10:21 MM/SS on a monthly basis. I'm trying to get the total minutes for the month which should be 5166 minutes.
I'm using the following statement to calculate it:
(avg(Session_Duration) ) * count(distinct upper(Authenticated_User))
Why don't you just do Sum(Session_Duration) to find the total duration?