Making an attribute regarding event-log

mmw922

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.

Thomas_Ott

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. 

Thomas_Ott

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. 

mmw922

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!