Skip to main content
Question

PQL formula

  • March 12, 2023
  • 2 replies
  • 3 views
E
Level 6
Forum|alt.badge.img+14
  • e.n
  • Level 6
  • 17 replies

I would like to create an OLAP table containing the following KPIs.

Could you please provide me with the formulas for the following four PQLs?

 

  • Number of cases passing through a particular activity
  • Number of cases that do not pass a specific activity
  • The number of cases coming from a specific activity to a specific activity
  • The number of cases that go from a specific activity to a specific activity

2 replies

badrinath.nooka13
Level 3
Forum|alt.badge.img+14

You can refer to below PQL Functions to create these KPI's

 

https://docs.celonis.com/en/match_activities.html

https://docs.celonis.com/en/match_process.html or https://docs.celonis.com/en/process-equals.html

E
Level 6
Forum|alt.badge.img+14
  • e.n
  • Author
  • Level 6
  • 17 replies
  • March 13, 2023

Thank you for your help. I'll try.


Community Code of ConductAccessibility statement