Counting a Running Column

[Jirong Hu]

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

 

[Biff]

Hi!

I have to question your logic on calculating the number of
active users.

Your first 3 entries are:

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