Hi!
I have to question your logic on calculating the number of
active users.
Your first 3 entries a
login
login
logout
Your number of active users is:
1
2
2
Seems to me that it should be:
1
2
1
And then follow that logic. Why would it NOT follow that
logic? How can you have 2 logins and 1 logout and still
have 2 active users?
Biff
-----Original Message-----
Hi
I have kind of data as follows. I want to create a graph
of the total number of login - logout vs. time elapse.
That is I want to create another two columns. One to
count the number of logins and another to count the
number of logouts.
I only have the data in the first column. What is the
function to create the second column, No.of Logins?
No.of Logins No.of Logout No.ActiveUsers
Login 1 0 1
Login 2 0 2
Logout 3 1 2
Logout 3 2 1
Login 4 2 2
Logout 4 3 1
Login 5 3 2
....
Thanks,
Jirong
.
|