Skip to main content

It is possible to create a table that is filled with defined variables that count certain tasks.

You see, in my organization we have 2 people responsible for the tasks, which would be the User and the Supplier. The User is responsible for 3 tasks and the Supplier for another 2, so I would like to make a table that appears

 


Responsible   #Quantity of tasks completed
User                       30
Supplier                   5

 

I can only add them as a column

COUNT (DISTINCT CASE WHEN "_CEL_CRED_ACTIVITIES_ARIBA"."LAPRO] Estado de la tarea" like 'Approved' OR "_CEL_CRED_ACTIVITIES_ARIBA"."LAPRO] Estado de la tarea" like 'Reviewed'and "_CEL_CRED_ACTIVITIES_ARIBA"."ACTIVITY_EN" like 'Revisión Usuario' THEN "_CEL_CRED_ACTIVITIES_ARIBA"."ACTIVITY_EN" ELSE   NULL END )

Hi, Daniel.
May I know what is wrong with the PQL that you have shared (apart from the DISTINCT )? If you add another column for "Responsible", then you should get the desired result. Or can you elaborate the problem? Can you maybe share expected vs. actual result?
 


Reply