Question
1
Replies
930
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
Your filter conditions should be appropriately used. For example
Filter 1: pyStatusWork = New
Filter 2: pxCreateDateTime = Today
Filter 3: pyStatusWorkstartswith 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