Question
Wipro
IN
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.
Pegasystems Inc.
US
Can you please tell me what course/version you are referring to so I may investigate this request?
Thanks,
Sean
Pega Academy Self-Study Support Team