Skip to main content
Solved

How to calculate the throughput time also for negative values (activities in different order)?

  • June 20, 2022
  • 3 replies
  • 16 views
A
Level 1

Is there a way to calculate the throughput time also for negative values (activites in different order) than start -> end in "throughput time search" visualization?

Like also having end -> start included in the same visualization, if there are variants that follow different order of activities.

The default of "throughput time search" is to only show variants that follow the defined order.

My work-around was to create custom datetime columns for the two activities in the case table, and then just use datediff calculation between two columns. But it seems rather clumsy way, and also binning is required to make it look nice..

Thank you for comments

Best answer by Anonymous

Dear @antti.järvi 

 

Please try DATEDIFF (celonis.com) function, that is possible to calculate negative value too.

 

I usually use this like

 

```

DATEDIFF(

        dd,

        PU_FIRST(VBAP,_CEL_MERGED_ACTIVITIES.TIMESTAMP,_CEL_MERGED_ACTIVITIES.ACTIVITY = 'Due Date passed: Invoice'),

        PU_FIRST(VBAP,_CEL_MERGED_ACTIVITIES.TIMESTAMP,_CEL_MERGED_ACTIVITIES.ACTIVITY = 'Clear Invoice'),

)

```

 

Best regards,

Kazuhiko

3 replies

.
Level 11

Hi @antti.järvi ,

 

This PQL statement computes the TPT regardless of which and the orders of the activities:

 

AVG(CALC_THROUGHPUT(ALL_OCCURRENCE['Process Start'] TO ALL_OCCURRENCE['Process End'], REMAP_TIMESTAMPS("ACTIVITIES"."EVENTTIME", DAYS)))

A
  • Anonymous
  • Answer
  • June 20, 2022

Dear @antti.järvi 

 

Please try DATEDIFF (celonis.com) function, that is possible to calculate negative value too.

 

I usually use this like

 

```

DATEDIFF(

        dd,

        PU_FIRST(VBAP,_CEL_MERGED_ACTIVITIES.TIMESTAMP,_CEL_MERGED_ACTIVITIES.ACTIVITY = 'Due Date passed: Invoice'),

        PU_FIRST(VBAP,_CEL_MERGED_ACTIVITIES.TIMESTAMP,_CEL_MERGED_ACTIVITIES.ACTIVITY = 'Clear Invoice'),

)

```

 

Best regards,

Kazuhiko

A
Level 1
  • antti.järvi
  • Author
  • Level 1
  • June 21, 2022

Dear @antti.järvi 

 

Please try DATEDIFF (celonis.com) function, that is possible to calculate negative value too.

 

I usually use this like

 

```

DATEDIFF(

        dd,

        PU_FIRST(VBAP,_CEL_MERGED_ACTIVITIES.TIMESTAMP,_CEL_MERGED_ACTIVITIES.ACTIVITY = 'Due Date passed: Invoice'),

        PU_FIRST(VBAP,_CEL_MERGED_ACTIVITIES.TIMESTAMP,_CEL_MERGED_ACTIVITIES.ACTIVITY = 'Clear Invoice'),

)

```

 

Best regards,

Kazuhiko

Works sweetly for my problem, now I just need to add logarithmic binning (as in throughput time search visualization)

Community Code of ConductAccessibility statement