Question

Hi, I want to determine the throughput time from start to end when activity "Authorize Payment is automatic (user type B), however the answer I get does not make sense at all - I expect a figure of 20hours + but only get 7.54 hours. What could

+6

AVG(CASE WHEN "el__activitytable"."ExecutionType" != 'B' AND

PROCESS

EQUALS

START 'e_custom_InitiatePayment' TO ANY TO 'e_custom_AuthorisePayment' TO ANY TO

'e_custom_ReportPayment'

then (CALC_THROUGHPUT(CASE_START TO CASE_END,

REMAP_TIMESTAMPS ("el__activitytable"."TIMESTAMP", hours))) ELSE 0 END)

+6

I manage to sort it out:

AVG(CASE WHEN (PROCESS EQUALS 'e_custom_AuthorisePayment' AND ${{user_type_column_name}}

!= '${{automatic_user_types}}')

then (

CALC_THROUGHPUT (

ALL_OCCURRENCE [ 'Process Start' ]

TO ALL_OCCURRENCE [ 'Process End' ] ,

REMAP_TIMESTAMPS (

TIMESTAMP_COLUMN ( ${{activity_table_case_centric}} ) ,

${{main_time_scale}} ))) ELSE NULL END)

hope it can help someone - the trick was not to use 0 but NULL and move the process equals up

Sign up