Making an attribute regarding event-log

Hi,
I have an event-log which has 'Activity' attribute and timestamps.
So I made a new attribute which numbering the sequence of activities in ascending order.
The problem is, I want to make a new attribute 'Previous Activity' and 'Next Activity' but don't know how to do it.
Please let me know the way. Thanks.
Best Answer
-
Take a look at the Lag operator in the Series Extension. This let's you create a new column that lags another column by some amount. Then you can rename it "Next Activity" or "Previous Activity" as the case maybe.
0
Answers
-
Take a look at the Lag operator in the Series Extension. This let's you create a new column that lags another column by some amount. Then you can rename it "Next Activity" or "Previous Activity" as the case maybe.
0 -
Thanks a lot!
I successfuly made 'Previous Activity' with the Lag operator but still not sure how to make 'Next Activity'. I thought if I typed -1 of lag it shows the result what I expected but it failed. If you have any idea about it, please let me know.
Anyway, thanks again!
1