I am trying to reconstruct the throuput times between two activities in an OLAP table (ROUND_MONTH(“CEL_LBU_ACTIVITIES”.“EVENTTIME”) as Dimension) as follows
AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[‘Activity1’] TO LAST_OCCURRENCE[‘Activity2’], REMAP_TIMESTAMPS(“CEL_LBU_ACTIVITIES”.“EVENTTIME”, HOURS))) .
To check the results I used the Throuput Time Search Component months by month (and FIRST_OCCURRENCE[‘Activity1’] and LAST_OCCURRENCE[‘Activity2’]) .
However, I get different results and don’t really understand, which one of them ist correct. What I want in the end is to get the average thoughput time between Activity1 and Activity2 for every respective month.
I would be really happy if someone could help me.