Find the second to last activity

Hello,

I am using PU_LAST to find the last activity in each case to find the user.

PU_LAST ("OCH_Cases", "OCH_Activities". "User_Group_NAM")

But now I always want to find the second to last activity. How could I do that?

Thank you

Regards,

Rene

Page 1 / 1

ACTIVITY_LAG(PU_LAST ("OCH_Cases", "OCH_Activities". "User_Group_NAM"))

or something like that

HTH

Hello. Thank you for your suggestion. Unfortunately, this does not work because "OCH_Cases" is not an activity table.

Do you have another idea to solve the problem?

Hello. Thank you for your suggestion. Unfortunately, this does not work because "OCH_Cases" is not an activity table.

Do you have another idea to solve the problem?

Then try LEAD(). I think you will need to add an order by term. Out of my place atm

Hello. Thank you for your suggestion. Unfortunately, this does not work because "OCH_Cases" is not an activity table.

Do you have another idea to solve the problem?

Then try LEAD(). I think you will need to add an order by term. Out of my place atm

If you need to find all the activities except for the first one, I would suggest to just print all of them, and then add a filter statement like activity != PU_FIRST(blabla)

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN