Report to display Open case Count on weekly basis.
I have an requirement to display the week based case count for particular case status on selection of Month and Year. For the case status time track we used pega OOTB declare index called pxTrackStatus in declare index join. We passed Month and Year in custom filter and send the param to start and end date of the pxTrackStatus. We used Week function to get the week start date in one column and SumOfPendingCases function to get the pending case count on weekly basis.
In this approach we can track only count of particular week.
For e.g: if the case has status pending-payment which was tracked on june 1st. If the case resolved on third week,the count of first and second week should be 1. But we get first week count as 1. For the second week we get 0.
please find the attachment. Kindly suggest an approach to achieve this.
Edited by Moderator Kayla to change type from General to Product and update platform capability tags****