How to build KPI for checking NO of Iteration of the activity (Create purchase Requisition) before the activity(Create purchase order).

Question

Hi,

I am facing an issue while getting the number of iteration of the activity purchase requisition before the activity purchase order.

if anyone have idea how can we get the activity occurrence so please help!

Thanks in advance.

deleted.delet27 · Answer

Hello,

You can try to use INDEX_ACTIVITY_ORDER funtion, with remap_values to get order of all activities. I would remapped all unwanted activities to NULL which would be then ignored by Index function.

Example: INDEX_ACTIVITY_ORDER ( REMAP_VALUES ( "Table1"."ACTIVITY" , [ 'A' , NULL ] ) )

Link 1: <your celonis link>/help/display/CIBC/INDEX_ACTIVITY_ORDER

Link 2: <your celonis link>/help/display/CIBC/REMAP_VALUES

Let us know it that helped.

Best Regards,

Mateusz Dudek

Sign up

Login with SSO

Login to the community

Login with SSO