Skip to main content
Question

It is possible to create a table whose feed is variables that perform operations such as counting

  • December 19, 2024
  • 1 reply
  • 32 views

daniel.magal
Level 1
Forum|alt.badge.img

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"."[APRO] Estado de la tarea" like 'Approved' OR "_CEL_CRED_ACTIVITIES_ARIBA"."[APRO] 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 )

1 reply

ayushi.chakr11
Celonaut
Forum|alt.badge.img+2
  • Celonaut
  • 4 replies
  • January 27, 2025

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?