Skip to main content

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

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


Thank you for your help. I'll try.


Reply