Nandhini Viswanathan (Nandhini21)

Nandhini21 Member since 2015 18 posts
Posted: June 18, 2019
Last activity: June 24, 2019
Posted: 18 Jun 2019 5:28 EDT
Last activity: 24 Jun 2019 17:24 EDT

Report total number of times an assignment is executed for all cases per month

Our case type is defined as such where stage 2 can repeat N number of times based on user action.

Stage 1 Stage 2
Initial Set up Step1: Implementation
Step2: Review

Given Start and End Date, business wants to download an excel which looks like below.

Month/Year Stage 2 Implementation Completed
01/2019 5
02/2019 1
03/2019 2

where, Stage 2 Implementation Completed count is the number of times the Step1 of Stage 2 got executed (considering all open and resolved cases belonging to this case type).

For example, if C-1 case has performed its implementation twice and

if C-2 has performed its implementation once in the same month, then

the count should be 3 for this month.

I intent to use pxStageHistory().pxProcesses(1).pxCompletedTime here.

Please suggest various design approaches to achieve this requirement.

Pega Academy
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.