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 )

Be the first to reply!

Reply