Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Badugu Naveen (BaduguN1) Tata Consultancy Services
Tata Consultancy Services
IN
BaduguN1 Member since 2014 8 posts
Tata Consultancy Services
Posted: Mar 25, 2016
Last activity: Mar 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

To see attachments, please log in.
Low-Code App Development Reporting

Posted: 8 years ago
Posted: 27 Mar 2016 6:41 EDT
Rajiv Nistala (nistr) 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

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice