Running dynamic count

[jonesen]

I wonder if anyone can help with this - I'm very new to Alteryx Designer...

I'm designing a workflow to parse FlexLM log files, what I'd like to do is create a running could of how many of x licences are checked out at any one time.

I have prepped the data and now have a timestamp column and a checkout column.

The checkout column contains either "OUT" or "IN" and describes whether a particular license feature (of say an arbitrary pool or 10) was checked out or checked back in.

So using this information id like to generate a *new* column ("new_column_count") of data containing a running count of licenses checked "OUT" - i.e starting with 1 have a column with a value for each row that was incremented by +1 each time "OUT" or -1 each time "IN" occurred, eg:

"checkout"   "new_column_count"

OUT                      1

OUT                      2

OUT                      3

OUT                      4

IN                          3

IN                          2

OUT                      3

IN                          2

IN                          1

IN                          0

OUT                      1

Any ideas would be much appreciated!

[mborriero · Accepted solution]

Hi @jonesen, in this case I would use a multi-row formula.

 Let me know if it helps.

[jonesen]

That's perfect -  Thanks very much!