Skip to main content

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

Hi @antti.järvi ,

 

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

 

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


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


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)


Reply