In the attached photo, the number of cases is duplicated and counted.
I want to know the PQL that solves this.
In the attached photo, the number of cases is duplicated and counted.
I want to know the PQL that solves this.
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.