Skip to main content
Question

Time between for specific activity loop

  • January 25, 2023
  • 3 replies
  • 9 views

Forum|alt.badge.img+14

Hi @all,

 

I have cases like this A-B-C-A-B-C or A-B-A-C-B-C like a loop with 3 activities, I want calculate between A and C activities. Also I have activity attribute for example first A-B-C activities have "ORDER" column value "1" and second A-B-C loop have "2". How can I calculate this situation?

Thanks, Selim

3 replies

  • Level 9
  • 77 replies
  • January 25, 2023

What exactly do you want to calculate, cause there are a lot of options here.

Do you want to know the time between the start of loop 1 until the time of start of loop 2?

so start of A-1 to start of A-2 ?


Forum|alt.badge.img+14
  • Author
  • Level 1
  • 1 reply
  • January 25, 2023

Thanks for answer. I want calculate start of A and start of C but both of them ORDER column values are must be same. Then will be continuously every A and C which activities have same order column values.


  • Level 8
  • 41 replies
  • January 31, 2023

I think you can find the detailed information at Help page by following Celonis Product Documentation> PQL - Process Query Language>Examples and Use Cases> Throughput Times.

 

You can use CALC_THROUGHPUT() function.