View Single Post
  #1  
Old 12-16-2014, 01:32 AM
chlain chlain is offline
Aspiring Member
 
Join Date: Dec 2013
Posts: 2
chlain has 10 reputation points
Smile CMS Report - Differentiate between Normal Call and Call Work Code

Hi All,

I am trying to create designer report which can have 2 tables or more inside. One table will show how many ACD Calls, ACD Times, ACW Times, Avg.HandlingTime, etc.

And another table will show ACD Calls, ACD Times, ACW Times, Avg.ACD Times, etc for Call Work Codes.

The first table will be based on dsplit and another table will be based on dcwc.

But I m facing issue to differentiate Non- Call Work Code call with Call Work Code call.

What I want to show is AHT for Call Work Code calls and AHT for Non-CWC call.

Is there any database items (Key) to join tables dsplit and dcwc?

Welcome any suggestions and appreciate. Pls help,
Reply With Quote