Question
1
Replies
931
Views
Posted: March 25, 2016
Last activity: March 27, 2016
Closed
Bar Graph Chart - Reports
Hi ,
We have a requirement, we need to pull the data from the Work Table.
We need to get the count of records for each status(pyStatusWork) and we have conditions on each Status.
For Ex:
for the status "New" & "Resolved-Completed" we need to get the count of records that are created or closed on that day.
For the "Delayed","Pending" we need to get the record count till date.
Could you some one help me out on the approach.
We are using Pega PRPC 7.1.8.
Thanks & Regards,
Naveen
Moderation Team has archived post,
Close popover
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.
Your filter conditions should be appropriately used. For example
Filter 1: pyStatusWork = New
Filter 2: pxCreateDateTime = Today
Filter 3: pyStatusWork startswith Resolved
Filter 4: pyResolveTimestamp = Today
Filter logic = (1 AND 2) OR (3 AND 4)
Now do a count on pyID and also put pyStatusWork as the group by