how can we write a Pql Statement to count the total cases which passing through the Activity

Dear Gulshan,

If you need it as a single KPI component (e.g. "Number"), you can use:

SUM(PU_COUNT_DISTINCT("CEL_CASE_TABLE","CEL_Activity_Table"."_ACTIVITY_EN", "CEL_Activity_Table"."_ACTIVITY_EN"='Chosen Activity Name'))

Replace the table parameters as it is named in your environment and choose the desired Activity which you want to count. The number should be equal to what you can see in the Process Explorer at the chosen Activity if no other filters are set.

Yours,

Zsolt Borbely