Skip to main content
Question

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

  • March 19, 2022
  • 1 reply
  • 2 views
T
Level 0
Forum|alt.badge.img+7

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.

1 reply

D
Level 0

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

Community Code of ConductAccessibility statement