I am trying to customize report using CUIC that display total no. of ACD calls associated with wrap-up codes by each CSQ/Application. I could not find any stock report that gives wrap-up code associate with CSQ/application.
Thanks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
You are correct, there are no stock wrap up reports. A set of wrap up reports were posted to the developer community here: Updated: Wrap Up Reports for CUIC 10.5 (not earlier!). You may find something of value in looking at those.
Regards,
Jack Parker
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Here's one Report Definition I wrote quite a while ago.
However, it could need some improvements if you feel that it's too slow to run.
SELECT
CT.EnterpriseName as CallType,
SUM(TCD01.Wrapup) as Handled,
TCD01.WrapupData as WrapupData
FROM
(SELECT
CallTypeID,
WrapupData,
Wrapup = Count(WrapupData)
FROM Termination_Call_Detail
WHERE CallTypeID IN (:CallType)
and DateTime >= :startDate
and DateTime <= :endDate
and WrapupData is not null
GROUP BY
CallTypeID, WrapupData
) TCD01
LEFT OUTER JOIN (SELECT
CallTypeID,
EnterpriseName
FROM Call_Type
WHERE CallTypeID IN (:CallType)
GROUP BY
CallTypeID, EnterpriseName
) CT
ON CT.CallTypeID=TCD01.CallTypeID
GROUP BY
CT.EnterpriseName, TCD01.WrapupData, TCD01.CallTypeID
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
That report is for UCCE... I think Rashmika is looking for a report for UCCX.
-Jameson
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Comments
0 comments
Please sign in to leave a comment.