Calculating throughput time for activities starting with..

#1

Hello,

I would like to calculate the throughput time of when first occurrence in table “ACTIVITIES”.“ActivityEN” beings with 'Start of…" instead of the below current code of ’ FIRST_OCCURRENCE [ ‘Posting invoice document’ ]

I currently have this:
AVG(CALC_THROUGHPUT( FIRST_OCCURRENCE [ ‘Posting invoice document’ ] TO LAST_OCCURRENCE [ ‘emphasized textPosting invoice document’ ], REMAP_TIMESTAMPS ( “ACTIVITIES”.“EventTime”,DAYS)))

Perhaps I need to use the pull_IN function but I am still not sure what the code is to take all activity beginning the ‘start of’ sequence.

I have several activities that I need to measure all found in the “ACTIVITIES”.“ActivityEN” table, example of a few below:

Start of APA WebCycle
Start of Conversation WebCycle
Start of Dunning letter
Start of FI Document Coding

please let me know if you can help!

0 Likes

#3

Hello,

you are right with your first idea of using the Pull function:

AVG(
    DAYS_BETWEEN(
        PU_FIRST("CASETABLE", "ACTIVITYTABLE"."EVENTTIME", "ACTIVITYTABLE"."ACTIVITY_EN" LIKE 'Start of%' ),
        PU_LAST("CASETABLE", "ACTIVITYTABLE"."EVENTTIME", "ACTIVITYTABLE"."ACTIVITY_EN" LIKE  'Start of%' )
    )
) 

With that code you measure the days it takes for the first “Start of…” activity to the last “Start of…” activity.

Best Regards,
Viana

1 Like