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!

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.