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!