Making an attribute regarding event-log

mmw922
mmw922 New Altair Community Member
edited November 2024 in Community Q&A

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.

Tagged:

Best Answer

  • Thomas_Ott
    Thomas_Ott New Altair Community Member
    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. 

Answers

  • Thomas_Ott
    Thomas_Ott New Altair Community Member
    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. 

  • mmw922
    mmw922 New Altair Community Member

    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!