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)
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 N 'Process Start' ]
TO ALL_OCCURRENCE R '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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
