Question

4
Replies
1689
Views
JAYAN1 Member since 2011 4 posts
PEGA
Posted: June 22, 2016
Last activity: July 8, 2016
Closed

How to use OOTB Balance of function in Report Definition?

How do I use Balance of < > items in status < > created < > resolved < > and last week < >? function to get a list of open, resolved tasks (cases) and group by operator?

User Story (Customer Requirement):

As a Manager, I need a report on list of open tasks and resolved tasks for the previous week and grouped by employee (operator).


Currently solution I am trying is building a custom report definition:


The report definition is under UGC-US-MI-CS-Work-UW and is configured as follows:


Query tab:

Column sourceColumn nameSummarizeSort TypeSort order
.pyStatusWorkECM CasesCount<blank>
Balance of <Resolved> items in status <.pyStatusWork> created <.pxCreateDateTime> resolved <.pyResolvedTimestamp> and last week <Current Week>


Edit Filters:

ConditionCaptionColumn sourceRelationshipValue
A.pxObjClassIs equal"UGC-US-MI-CS-Work-UW-ECM"

 

Reporting
Moderation Team has archived post
Share this page LinkedIn