Skip to main content
Question

Is it possible to display the number of cases for each rework count?

  • March 3, 2022
  • 1 reply
  • 2 views

Forum|alt.badge.img+11

In the attached photo, the number of cases is duplicated and counted.

I want to know the PQL that solves this.

2

1 reply

  • Celonaut
  • March 30, 2022

Hello Ryotaro,

 

If I understand your issue correctly, If you hide or delete the "activity" dimension, you should get the amount cases per recount.

 

Also take into account that rework is an activity level data, therefore you should probably either look for number of activities with a given rework count or number of cases with any activity with rework higher than X (that last option probably can be accomplished with PU_MAX function).

 

Hope this guides you to solve your issue.

 

Best regards,

Pablo