Calculate throughput with activity exclusion

#1

Dear Colleagues,

I am trying to calculate throughput time using standard PQL statement:
(CALC_THROUGHPUT(FIRST_OCCURRENCE[‘activity1’] TO LAST_OCCURRENCE[‘activity2’], REMAP_TIMESTAMPS(“eventlog”.“eventtime”, DAYS))CALC_THROUGHPUT(FIRST_OCCURRENCE[‘activity1’] TO LAST_OCCURRENCE[‘activity2’], REMAP_TIMESTAMPS(“eventlog”.“eventtime”, DAYS))

There is one problem which we cannot easiliy overcome with our source data.
Our OCR tool sometimes does not recognize the dates correctly and stores wrong values (for example 17.05.5698). Is it possible to calculate throughput with additional filter to completely exclude activity from calculation? I have tried to also somehow incorporate statement REMAP_VALUES("_CEL_P2P_ACTIVITIES".“ACTIVITY_EN”, [‘Scan Invoice’, NULL]) but did not come up with correct statement.

Thank you in advance for suggestions

0 Likes

#2

Hi,

you can try using the formula

DAYS_BETWEEN(
    PU_FIRST("EKPO", "_CEL_P2P_ACTIVITIES"."EVENTTIME", "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" = 'activity1' ),
    PU_LAST("EKPO", "_CEL_P2P_ACTIVITIES"."EVENTTIME", "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" = 'activity2' )
)

In case you want to additionally filter out certain date values you can also add that to your third condition in the PU:

DAYS_BETWEEN(
        PU_FIRST("EKPO", "_CEL_P2P_ACTIVITIES"."EVENTTIME", "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" = 'activity1'  AND ROUND_DAY(DATECOLUMN) < {d'2100-01-01'}   ),
        PU_LAST("EKPO", "_CEL_P2P_ACTIVITIES"."EVENTTIME", "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" = 'activity2' AND ROUND_DAY(DATECOLUMN) < {d'2100-01-01'}  )
    )

Best regards,
Viana

0 Likes