Umamageswari G (UmamageswariG0622)
Hexaware Technologies Ltd

Hexaware Technologies Ltd
UmamageswariG0622 Member since 2018 9 posts
Hexaware Technologies Ltd
Posted: July 9, 2020
Last activity: July 16, 2020
Posted: 9 Jul 2020 9:23 EDT
Last activity: 16 Jul 2020 0:03 EDT

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****  

Pega Platform 8.3.1 Case Management
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.