Skip to main content
Question

How to identify Avg time spent on one activity using PQL

  • Apr 4, 2023 4:08 AM UTC
  • 3 replies
  • 134 views

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 ,

3 replies

  • Apr 4, 2023 6:07 AM UTC

Can you use  CALC_THROUGHPUT ( begin_range_specifier TO end_range_specifier, timestamps [, activity_table.string_column ] ) Syntax?


  • Apr 4, 2023 6:19 AM UTC

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


  • Apr 4, 2023 6:21 AM UTC

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 . :)