Busienss days calculation on pxcreatedate column In Report definition
Hi ,
I have requirement to fetch the Assignments that are more than 3 business days in the work basket.
So do we have any option of calculating this based on routing time of assignment to Workbasket in Report definition directly.
Thanks in Advance,
Janakiram
Posted: 1 year ago
Posted: 1 year ago
HI priya,
This reports will not calculate the business days, right ?
so we cannot use this implementation in my requirement as there is no SLA define on the Assignments which are in our WB, If so also we can not calculate the business days .
Hi @johnny25,
Thank you for posting your query here.
There is a OOTB Report that does a similar function as you described.
Launch Case Manager portal and open the Report browser. In "Monitor Assignments" Public category, open "Timeliness by work queue" Report.
This Report will group by the workbasket the operator belongs to. When you click on any particular workbasket, a drill down report will be shown. Here the Work objects corresponding to the assignment routed to the work queue and Date time of when it was assigned will be available.
To understand the configuration, open the report definitions in designer studio and achieve your implementation.
pyAgeByWorkQueue ( Timeliness by work queue ) and pyDrillToDetails ( Workbasket Drilldown Details )
Hope this helps your requirement.
Regards,
Priyabharathi