Skip to main content
Question

how can we write a Pql Statement to count the activities passes through the cases

  • October 13, 2023
  • 2 replies
  • 38 views

Forum|alt.badge.img+7
how can we write a Pql Statement to count the activities passes through the cases

2 replies

Forum|alt.badge.img+6
  • Level 0
  • 34 replies
  • October 16, 2023
Hi, I would suggest taking the following academy course for your reference. https://academy.celonis.com/learn/course/use-pu-functions-in-analyses

dxb.miner
Level 5
  • Level 5
  • 13 replies
  • November 14, 2024

In an OLAP table just add the case key from case table in dimension and in the KPI add count_table(activities_table). It should work. Just replace the activities_table with your activity table name.