Skip to main content

Dear Colleges,

 

I am trying to set a filter at my Pivot Table I would like to have the "1" of each activity to know the users that performed more than one activity in a process. I am trying for two days with success.

 

Best Regards Raphael Correa

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

Reply


Terms & ConditionsCookie settings