Dear Colleges,

Hi @raphael.corre,

Thanks for approaching the Celonis Community! I am happy to help!

Can you please provide some details on what you want to achieve?

It would be great if you could share a screenshot of the table and the PQL formulas that you use for each dimension and KPI. Also it would be amazing if you could explain in detail what you want to acieve.

Best,

Justin

Hi Raphael,

this can be easily achieve by using PU Functions.Count on a case level how many activities were performed by a user and filter count >1:

Right click on the Pivot table->component filter and add:

FILTER PU_COUNT(CaseTable, Table.User) >1;

As dimensions for your Pivot table, add CaseID and the user ID. As the KPI, add the Acitivity Count.Best,

Gabriel