Question

1
Replies
938
Views
 Badugu Naveen (BaduguN1)
Tata Consultancy Services

Tata Consultancy Services
IN
BaduguN1 Member since 2014 8 posts
Tata Consultancy Services
Posted: March 25, 2016
Last activity: March 27, 2016
Posted: 25 Mar 2016 12:09 EDT
Last activity: 27 Mar 2016 6:41 EDT
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

Low-Code App Development Reporting
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.
Posted: 5 years ago
Posted: 27 Mar 2016 6:41 EDT
Rajiv Nistala (nistr)
PEGA
Senior Manager - Engineering
Pegasystems
IN

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