Hi All, | Community

Hi All,

I am trying to take my activity table and break it out into different subactivtiies groupings. Basically trying to create a counter calculation by case whenever the activity is 'Start' and have it copy all the way down until the next 'Start' activity or using a sort of lead object to distinguish the beginning of a sub activity.

Example:

Case Activitiy Counter

1 Start 1

1 Activity 1

1 Start 2

1 Activity 2

2 Start 1

2 Activity 1

I have tried to do this with a variety of formulas, but have been unable to recreate this. I can do this in the backend transformation, but would prefer to see if it can be done within a calc from the front end.

Please advise whenever you get a chance. Thanks for reading!

Page 1 / 1

Not 100% sure, but I think this can help you

https://docs.celonis.com/en/index_activity_type.html

HTH

Thank you I tried that previously and couldnt get it working.

I did get the backend ETL working with this snipet:

SUM(CASE WHEN Activity = 'Start' THEN 1 ELSE 0 END) OVER (ORDER BY ID) AS Counter

In the 1 Start 1, 1 Start 2, are the bolded part the name of the acitivites?

if thats the case, can you remap values to everything to be activity 1, activity 2, .... and then use index activity type to rename the first acitity 1 to be start 1, first activity 2 to be start 2?

May be you can use below logic, not sure if this solves the entire purpose.

you can use PU_FIRST of sub activity and in the filter condition you can use remap values to rename as 1 = 'Start 1' inside a case when where pu_first will be in when condition and else condition can be given as same activity name

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