Dear experts, Lets say there is activity Y that i want to know average time spent on , Also in this there are n number of activities preceding it and n number of activities following it. which i dont care. Will it be possible to identify avg time spent on this activity using PQL ?
Thanks in advance ,
+14Can you use CALC_THROUGHPUT ( begin_range_specifier TO end_range_specifier, timestamps [, activity_table.string_column ] ) Syntax？
Time spent is either the time from the previous activity, or the time TO the next activity
Use CALC_THROUGHPUT and ACTIVITY_LEAD / ACTIVITY_LAG
HTH
Actually i Just found , if we use LAG operator to do this , it will be achieved. I was trying to use the solution you mentioned , basically it will take end activity as "Y" but it wont take immediate preceding activity but it will take starting activity and calculate throughput time . Neverthless thank you very much for reading my question and responding to this . :)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
