Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

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.

Find more posts tagged with

AI Studio

Accepted answers

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.

All comments

Thomas_Ott

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!