Built motion from commit 8dca541896b0ff92bb88a36cc13f4f385b593b4b. Version 3.0.0...

[motion-next.git] / server / config / seedDB / report / fields.js

diff --git a/server/config/seedDB/report/fields.js b/server/config/seedDB/report/fields.js
index dd7d188..0f32db0 100644 (file)
--- a/server/config/seedDB/report/fields.js
+++ b/server/config/seedDB/report/fields.js
@@ -1 +1 @@
-const a869_0x18b1=['HangupReason','report_fax_queue.id','ROUND(AVG(duration))','Answered\x2020-30s','Negative(%)','Abandoned<10s','UserId','sms_interactions.createdAt','Calls','TalkTime','CASE\x20WHEN\x20type=\x27LOGIN\x27\x20THEN\x20UNIX_TIMESTAMP(exitAt)-UNIX_TIMESTAMP(enterAt)\x20END','QueueAbandon','JoinAt','Reason','Answer\x20Rate\x2010-20s','Mixed(%)','chat_interactions.id','agentconnectAt','tag','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)))','COUNT(IF(closed=1\x20&&\x20disposition\x20=\x27abandoned\x27,1,NULL))','Total\x20(%)','Global\x20Count','Recorded\x20Calls','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(whatsapp_interactions.createdAt)','Sms\x20Account','holdtime','CONCAT(ROUND((\x20(SELECT\x20COUNT(IF(voice_recordings.sentiment\x20=\x20\x27POSITIVE\x27,1,NULL)))*100/\x20COUNT\x20(voice_recordings.sentiment)),2),\x27%\x27)','AVG\x20Interaction\x20Time','agentacw','whatsapp_queues.name','QueueAbandonAt','Event','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(mail_interactions.createdAt)','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(chat_interactions.createdAt)','disposition','rating','chat_queues.name','UNIX_TIMESTAMP(leaveAt)-UNIX_TIMESTAMP(joinAt)','COUNT(IF(reason=\x27accepted\x27,1,NULL))','campaign','Penetration\x20Rate','ROUND(count(id)*100/(SELECT\x20COUNT(*)\x20FROM\x20cm_hopper_history\x20WHERE\x20campaigntype=\x27ivr\x27),2)','chat_interactions.closed','QueueJoinAt','answertime','UNIX_TIMESTAMP(queuecallerExitAt)-UNIX_TIMESTAMP(queuecallerjoinAt)','AgentACW','UniqueId','COUNT\x20(IF(voice_recordings.sentiment\x20=\x20\x27POSITIVE\x27,1,NULL))','users.fullname','NEGATIVE','ROUND(AVG(UNIX_TIMESTAMP(queuecallerExitAt)-UNIX_TIMESTAMP(queuecallerjoinAt)))','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)','mail_interactions.closed','Closed','ROUND(COUNT(IF(closed=1\x20&&\x20disposition=\x27unmanaged\x27,1,NULL))/COUNT(id)\x20*100,1)','whatsapp_interactions.closed','mail_accounts.name','whatsapp_interactions.createdAt','Avg\x20Rating','BlackList','ROUND(COUNT(id)*100/(SELECT\x20COUNT(*)\x20FROM\x20cm_hopper_final\x20WHERE\x20state=4\x20and\x20campaigntype=\x27queue\x27),2)','SUM','Answered\x20<10s','CallerID','Avg\x20Duration','Destination','End\x20Time','Full\x20Name','uniqueid','Completed\x20(%)','COUNT(IF(reason=\x27timeout\x27,1,NULL))','Abandoned\x20Rate<10s','ROUND(COUNT(IF(holdtime<10,1,NULL))\x20/\x20SUM(agentcomplete)\x20*100,1)','Answer\x20Rate','Day','COUNT(IF(holdtime\x20>=10\x20AND\x20holdtime\x20<20,1,NULL))','Agent','ROUND(COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20<10,1,NULL))\x20/\x20SUM(queuecallerabandon)\x20*100,1)','CASE\x20WHEN\x20type=\x27PAUSE\x27\x20THEN\x20UNIX_TIMESTAMP(exitAt)-UNIX_TIMESTAMP(enterAt)\x20END','destinationchannel','billableseconds','openchannel_interactions.closed','fax_queues.name','StartTime','SUBSTRING_INDEX(channel,\x20\x22-\x22,\x201)','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(sms_interactions.createdAt)))','Interface','Avg\x20TalkTime','COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20>=10\x20AND\x20UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20<60,1,NULL))','agentcalledAt','Whatsapp\x20Account','Total\x20Calls','talktime\x20+\x20acwtime','CASE\x20WHEN\x20queuecallercomplete=1\x20THEN\x20\x27YES\x27\x20ELSE\x20\x27NO\x27\x20END','voice_recordings.UserId','COUNT\x20DISTINCT','Unique\x20Id','Abandoned>120s','sms_queues.name','AbandonAt','sms_interactions.id','fax_interactions.createdAt','Interactions','Total\x20Rating','report_chat_queue.id','DATE','queuecallerexit','TotHandleTime','COUNT(IF(holdtime\x20>=30,1,NULL))','dropreason','exten','agentcompleteAt','Answer\x20Rate\x2020-30s','AbandonTime','ROUND(COUNT(IF(holdtime\x20>=30,1,NULL))\x20/\x20SUM(agentcomplete)\x20*100,1)','Hold\x20Time','QueueExitReason','queuecallerabandonAt','Calls\x20(%)','Tot\x20Abandoned','HOUR','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(fax_interactions.createdAt)))','agentcomplete','report_mail_queue.id','openchannel_queues.name','COUNT(IF(holdtime<10,1,NULL))','leaveAt','Abandoned\x2010-60s','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(fax_interactions.createdAt)','Abandoned\x20Rate>120s','Drop\x20Reason','ROUND(AVG(acwtime))','voice_recordings.sentiment','NEUTRAL','EnterAt','COUNT(IF(closed=1\x20&&\x20disposition\x20=\x27unmanaged\x27,1,NULL))','UNIX_TIMESTAMP(exitAt)-UNIX_TIMESTAMP(enterAt)','ROUND(COUNT(IF(holdtime\x20>=20\x20AND\x20holdtime\x20<30,1,NULL))\x20/\x20SUM(agentcomplete)\x20*100,1)','openchannel_accounts.name','DayOfWeek','COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20<10,1,NULL))','Contacts','Answer\x20Rate\x20<10s','HoldTime','DAYNAME(queuecallerjoinat)','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(chat_interactions.createdAt)))','Openchannel\x20Account','ListId','AgentExtension','CASE\x20WHEN\x20queuecallercomplete=1\x20THEN\x20queuecallercompleteAt\x20ELSE\x20queuecallerLeaveAt\x20END','Campaign\x20Name','Tot\x20Answered','Queue','queuecallercomplete','ROUND(AVG(holdtime))','starttime','chat_websites.name','QueueExitAt','ASC','Avg\x20ACWTime','talktime','Source','fax_interactions.id','Web\x20Site','AvgACWTime','whatsapp_accounts.name','queuecallerexitAt','AVG','Abandoned','Offered','AvgHandleTime','ExitAt','COUNT(IF(holdtime\x20>=20\x20AND\x20holdtime\x20<30,1,NULL))','Disposition','Complete','queuecallerjoinAt','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(openchannel_interactions.createdAt)','ROUND(COUNT(IF(closed=1\x20&&\x20((disposition\x20!=\x27unmanaged\x27\x20&&\x20disposition\x20!=\x27abandoned\x27)\x20||\x20disposition\x20IS\x20NULL),1,NULL))/COUNT(id)\x20*100,1)','Answered\x20>30s','Managed','POSITIVE','ROUND(AVG(UNIX_TIMESTAMP(queuecallercompleteAt)-UNIX_TIMESTAMP(queuecallerleaveAt)))','calleridnum','PauseType','joinAt','lastevent','membername','endtime','COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20>=60\x20AND\x20UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20<120,1,NULL))','ReportId','exitAt','reason','Completed','data1','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(whatsapp_interactions.createdAt)))','queue','AgentACWTime','ROUND(SUM(talktime\x20+\x20acwtime)/COUNT(agentcomplete))','Email\x20Account','queuecallerexitreason','ROUND(COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20>=120,1,NULL))\x20\x20/\x20SUM(queuecallerabandon)\x20*100,1)','ROUND(COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20>=10\x20AND\x20UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20<60,1,NULL))\x20\x20/\x20SUM(queuecallerabandon)\x20*100,1)','AnswerTime','queuecallercompleteAt','Talk\x20Time','Tot\x20HoldTime','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(mail_interactions.createdAt)))','ROUND(AVG(talktime))','countglobal','queuecallerjoinat','QueueLeaveAt','EndTime','Sentiment\x20TOT','TotTalkTime','Unmanaged\x20HoldTime','COUNT(IF(closed=0,1,NULL))','LastCallAt','UniqueID','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(sms_interactions.createdAt)','SUM(IF(state=4,1,0))','AgentConnectAt','Type','AgentComplete','data','DID','ROUND(COUNT(IF(closed=1,1,NULL))/COUNT(id)\x20*100,1)','Tot\x20AbandonTime','CONCAT(ROUND((\x20(SELECT\x20COUNT(IF(voice_recordings.sentiment\x20=\x20\x27NEUTRAL\x27,1,NULL)))*100/\x20COUNT\x20(voice_recordings.sentiment)),2),\x27%\x27)','project_name','mail_interactions.createdAt','QueuePosition','lodash','type','statedesc','Abandoned\x20(%)','Open','mail_interactions.id','COUNT','Answered\x2010-20s','ROUND(SUM(queuecallercomplete)/COUNT(DISTINCT\x20uniqueid)*100,1)','Positive(%)','report_whatsapp_queue.id','Neutral(%)','queuecallerabandon','Data','Login\x20Time','Abandon\x20Time','Block','Tot\x20TalkTime','groupBy','UNIX_TIMESTAMP(queuecallercompleteAt)-UNIX_TIMESTAMP(queuecallerleaveAt)','MIXED','Answer\x20Rate\x20>30s','position','fax_accounts.name','mail_queues.name','Date','whatsapp_interactions.id','CompleteAt','DESC','COUNT(IF(closed=1,1,NULL))','Unmanaged','source','AgentCompleteAt','report_openchannel_queue.id','Total','Tot\x20Duration','Duration','CallerId','calleridname','ROUND(AVG(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)))','Abandon','LastEvent','Tot\x20Unmanaged\x20Time','Tot\x20Handle\x20Time','Pause','chat_interactions.createdAt','AVG\x20Hold\x20Time','COUNT\x20(IF(voice_recordings.sentiment\x20=\x20\x27NEGATIVE\x27,1,NULL))','sms_accounts.name','COUNT\x20(IF(voice_recordings.sentiment\x20=\x20\x27NEUTRAL\x27,1,NULL))','exports','SEC_TO_TIME(AVG(talktime))','blacklist','Fax\x20Account','LastApp','CONCAT(ROUND((\x20(SELECT\x20COUNT(IF(voice_recordings.sentiment\x20=\x20\x27MIXED\x27,1,NULL)))*100/\x20COUNT\x20(voice_recordings.sentiment)),2),\x27%\x27)','ROUND(AVG(UNIX_TIMESTAMP(leaveAt)-UNIX_TIMESTAMP(joinAt)))','CallerIdNum','ROUND(SUM(IF(state=4,1,0))/COUNT(*)*100,1)','lastapplication','Hour','openchannel_interactions.id','queuecallerleaveAt','duration','Project\x20Name','report_sms_queue.id','Interaction\x20Time','SEC_TO_TIME','callerid','Answered','CONCAT(ROUND((\x20(SELECT\x20COUNT(IF(voice_recordings.sentiment\x20=\x20\x27NEGATIVE\x27,1,NULL)))*100/\x20COUNT\x20(voice_recordings.sentiment)),2),\x27%\x27)','State','Timeout','acwtime','Accepted','AvgAbandonTime','Avg\x20Handle\x20Time','enterAt','Pause\x20Time','COUNT(IF(closed=1\x20&&\x20((disposition\x20!=\x27unmanaged\x27\x20&&\x20disposition\x20!=\x27abandoned\x27)\x20||\x20disposition\x20IS\x20NULL),1,NULL))','AvgTalkTime','ROUND(COUNT(IF(holdtime\x20>=10\x20AND\x20holdtime\x20<20,1,NULL))\x20/\x20SUM(agentcomplete)\x20*100,1)','Abandoned\x20Rate\x2010-60s','Avg\x20HoldTime'];(function(_0x446887,_0x18b155){const _0x14d227=function(_0x10c877){while(--_0x10c877){_0x446887['push'](_0x446887['shift']());}};_0x14d227(++_0x18b155);}(a869_0x18b1,0x1aa));const a869_0x14d2=function(_0x446887,_0x18b155){_0x446887=_0x446887-0x0;let _0x14d227=a869_0x18b1[_0x446887];return _0x14d227;};const _0xc25bc7=a869_0x14d2;'use strict';const _=require(_0xc25bc7('0x7c'));module[_0xc25bc7('0xae')]=function(){const _0x3629ab=_0xc25bc7,_0x10c877=[{'field':'uniqueid','alias':_0x3629ab('0x100'),'ReportId':0x1},{'field':_0x3629ab('0x4b'),'alias':_0x3629ab('0xb5'),'ReportId':0x1},{'field':'calleridname','alias':'CallerIdName','ReportId':0x1},{'field':_0x3629ab('0x58'),'alias':_0x3629ab('0x2d'),'ReportId':0x1},{'field':_0x3629ab('0x44'),'alias':_0x3629ab('0xfc'),'ReportId':0x1},{'field':_0x3629ab('0xba'),'alias':_0x3629ab('0x67'),'ReportId':0x1},{'field':_0x3629ab('0x88'),'alias':_0x3629ab('0xdb'),'ReportId':0x1},{'field':_0x3629ab('0xa'),'alias':_0x3629ab('0xef'),'ReportId':0x1},{'field':_0x3629ab('0x2e'),'alias':_0x3629ab('0x43'),'ReportId':0x1},{'field':_0x3629ab('0x60'),'alias':_0x3629ab('0x97'),'ReportId':0x1},{'field':_0x3629ab('0x13c'),'alias':'QueueExit','ReportId':0x1},{'field':_0x3629ab('0x3b'),'alias':_0x3629ab('0x32'),'ReportId':0x1},{'field':_0x3629ab('0x5c'),'alias':_0x3629ab('0x9'),'ReportId':0x1},{'field':_0x3629ab('0x3'),'alias':_0x3629ab('0x75'),'ReportId':0x1},{'field':'UNIX_TIMESTAMP(queuecallercompleteAt)-UNIX_TIMESTAMP(queuecallerleaveAt)','alias':_0x3629ab('0xd9'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x1},{'field':'UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)','alias':_0x3629ab('0x6'),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0x1},{'field':'IF(queuecallercomplete=1,holdtime,null)','alias':_0x3629ab('0x5f'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x1},{'field':_0x3629ab('0x4b'),'alias':_0x3629ab('0x111'),'ReportId':0x2},{'field':_0x3629ab('0x58'),'alias':_0x3629ab('0x2d'),'ReportId':0x2},{'field':_0x3629ab('0x44'),'alias':'StartTime','ReportId':0x2},{'field':_0x3629ab('0x2a'),'alias':'EndTime','custom':0x1,'ReportId':0x2},{'field':_0x3629ab('0xea'),'alias':_0x3629ab('0x24'),'format':_0x3629ab('0xbf'),'ReportId':0x2},{'field':_0x3629ab('0x12f'),'alias':_0x3629ab('0xc1'),'custom':0x1,'ReportId':0x2},{'field':_0x3629ab('0x116'),'alias':_0x3629ab('0x100'),'ReportId':0x3},{'field':'calleridnum','alias':_0x3629ab('0xb5'),'ReportId':0x3},{'field':_0x3629ab('0xa2'),'alias':'CallerIdName','ReportId':0x3},{'field':_0x3629ab('0x58'),'alias':_0x3629ab('0x2d'),'ReportId':0x3},{'field':_0x3629ab('0x4f'),'alias':_0x3629ab('0x11e'),'ReportId':0x3},{'field':_0x3629ab('0x12b'),'alias':'AgentCalledAt','ReportId':0x3},{'field':'agentconnectAt','alias':_0x3629ab('0x71'),'ReportId':0x3},{'field':_0x3629ab('0x4'),'alias':_0x3629ab('0x9c'),'ReportId':0x3},{'field':_0x3629ab('0xea'),'alias':_0x3629ab('0x5f'),'ReportId':0x3},{'field':_0x3629ab('0x35'),'alias':_0x3629ab('0xd9'),'ReportId':0x3},{'field':_0x3629ab('0xed'),'alias':_0x3629ab('0xff'),'ReportId':0x3},{'field':_0x3629ab('0xc5'),'alias':_0x3629ab('0x59'),'ReportId':0x3},{'field':_0x3629ab('0xf'),'alias':_0x3629ab('0x73'),'ReportId':0x3},{'field':_0x3629ab('0x54'),'alias':_0x3629ab('0xd0'),'ReportId':0x3},{'field':_0x3629ab('0x4e'),'alias':_0x3629ab('0xa5'),'ReportId':0x3},{'field':_0x3629ab('0x3'),'alias':'DID','ReportId':0x3},{'field':_0x3629ab('0x4f'),'alias':_0x3629ab('0x11e'),'groupBy':0x1,'ReportId':0x4},{'field':_0x3629ab('0xf'),'alias':_0x3629ab('0x55'),'function':_0x3629ab('0x10f'),'ReportId':0x4},{'field':_0x3629ab('0x35'),'alias':_0x3629ab('0x6a'),'function':'SUM','format':'SEC_TO_TIME','ReportId':0x4},{'field':_0x3629ab('0xc5'),'alias':'TotACWTime','function':_0x3629ab('0x10f'),'format':'SEC_TO_TIME','ReportId':0x4},{'field':_0x3629ab('0x12e'),'alias':_0x3629ab('0x0'),'function':_0x3629ab('0x10f'),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0x4},{'field':_0x3629ab('0x64'),'alias':_0x3629ab('0xcc'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x4},{'field':_0x3629ab('0x18'),'alias':_0x3629ab('0x39'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x4},{'field':_0x3629ab('0x5a'),'alias':_0x3629ab('0x3f'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x4},{'field':_0x3629ab('0x58'),'alias':_0x3629ab('0x2d'),'groupBy':0x1,'ReportId':0x5},{'field':_0x3629ab('0xf'),'alias':_0x3629ab('0x55'),'function':_0x3629ab('0x10f'),'ReportId':0x5},{'field':_0x3629ab('0x35'),'alias':'Tot\x20TalkTime','function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'ReportId':0x5},{'field':'holdtime','alias':_0x3629ab('0x62'),'function':'SUM','format':_0x3629ab('0xbf'),'ReportId':0x5},{'field':'acwtime','alias':'Tot\x20ACWTime','function':'SUM','format':_0x3629ab('0xbf'),'ReportId':0x5},{'field':'talktime\x20+\x20acwtime','alias':_0x3629ab('0xa7'),'function':'SUM','format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x5},{'field':'ROUND(AVG(talktime))','alias':_0x3629ab('0x129'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x5},{'field':_0x3629ab('0x2f'),'alias':_0x3629ab('0xcf'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x5},{'field':_0x3629ab('0x18'),'alias':_0x3629ab('0x34'),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0x5},{'field':_0x3629ab('0x5a'),'alias':_0x3629ab('0xc8'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x5},{'field':_0x3629ab('0x58'),'alias':_0x3629ab('0x2d'),'groupBy':0x1,'ReportId':0x6},{'field':_0x3629ab('0xf'),'alias':_0x3629ab('0x2c'),'function':'SUM','ReportId':0x6},{'field':_0x3629ab('0x12'),'alias':_0x3629ab('0x110'),'custom':0x1,'ReportId':0x6},{'field':_0x3629ab('0x11a'),'alias':_0x3629ab('0x23'),'custom':0x1,'ReportId':0x6},{'field':'COUNT(IF(holdtime\x20>=10\x20AND\x20holdtime\x20<20,1,NULL))','alias':_0x3629ab('0x83'),'custom':0x1,'ReportId':0x6},{'field':_0x3629ab('0xcd'),'alias':_0x3629ab('0xde'),'custom':0x1,'ReportId':0x6},{'field':_0x3629ab('0x41'),'alias':'Answered\x2020-30s','custom':0x1,'ReportId':0x6},{'field':_0x3629ab('0x1e'),'alias':_0x3629ab('0x5'),'custom':0x1,'ReportId':0x6},{'field':_0x3629ab('0x1'),'alias':'Answered\x20>30s','custom':0x1,'ReportId':0x6},{'field':_0x3629ab('0x7'),'alias':_0x3629ab('0x91'),'custom':0x1,'ReportId':0x6},{'field':_0x3629ab('0x54'),'alias':_0x3629ab('0xdd'),'groupBy':0x1,'ReportId':0x7},{'field':_0x3629ab('0x116'),'alias':_0x3629ab('0xd8'),'function':_0x3629ab('0x82'),'ReportId':0x7},{'field':_0x3629ab('0xe1'),'alias':_0x3629ab('0xb8'),'format':_0x3629ab('0xd'),'groupBy':0x1,'ReportId':0x8},{'field':_0x3629ab('0xf'),'alias':'Tot\x20Answered','function':_0x3629ab('0x10f'),'ReportId':0x8},{'field':_0x3629ab('0x12'),'alias':_0x3629ab('0x110'),'custom':0x1,'ReportId':0x8},{'field':_0x3629ab('0x11d'),'alias':_0x3629ab('0x83'),'custom':0x1,'ReportId':0x8},{'field':_0x3629ab('0x41'),'alias':_0x3629ab('0xd3'),'custom':0x1,'ReportId':0x8},{'field':_0x3629ab('0x1'),'alias':_0x3629ab('0x47'),'custom':0x1,'ReportId':0x8},{'field':_0x3629ab('0x116'),'alias':_0x3629ab('0x100'),'ReportId':0x9},{'field':_0x3629ab('0x4b'),'alias':'CallerIdNum','ReportId':0x9},{'field':_0x3629ab('0x58'),'alias':_0x3629ab('0x2d'),'ReportId':0x9},{'field':'queuecallerjoinAt','alias':_0x3629ab('0xdc'),'ReportId':0x9},{'field':'queuecallerleaveAt','alias':'LeaveAt','ReportId':0x9},{'field':_0x3629ab('0x88'),'alias':_0x3629ab('0xa4'),'ReportId':0x9},{'field':'queuecallerabandonAt','alias':_0x3629ab('0x135'),'ReportId':0x9},{'field':_0x3629ab('0x13c'),'alias':_0x3629ab('0x9a'),'ReportId':0x9},{'field':_0x3629ab('0x3b'),'alias':'UnmanagedAt','ReportId':0x9},{'field':'queuecallerexitreason','alias':'UnmanagedReason','ReportId':0x9},{'field':_0x3629ab('0x92'),'alias':_0x3629ab('0x7b'),'ReportId':0x9},{'field':_0x3629ab('0x3'),'alias':_0x3629ab('0x75'),'ReportId':0x9},{'field':'UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)','alias':_0x3629ab('0x8b'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x9},{'field':_0x3629ab('0xfe'),'alias':_0x3629ab('0x6b'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x9},{'field':_0x3629ab('0x58'),'alias':'Queue','groupBy':0x1,'ReportId':0xa},{'field':_0x3629ab('0x88'),'alias':_0x3629ab('0x3d'),'function':_0x3629ab('0x10f'),'ReportId':0xa},{'field':_0x3629ab('0x13c'),'alias':_0x3629ab('0x9a'),'function':'SUM','ReportId':0xa},{'field':'UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)','alias':_0x3629ab('0x77'),'function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0xa},{'field':_0x3629ab('0xa3'),'alias':_0x3629ab('0xc7'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0xa},{'field':_0x3629ab('0xfe'),'alias':_0x3629ab('0xa6'),'function':'SUM','format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0xa},{'field':_0x3629ab('0x104'),'alias':'Avg\x20Unmanaged\x20TIme','format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0xa},{'field':_0x3629ab('0x5c'),'alias':_0x3629ab('0xdd'),'groupBy':0x1,'ReportId':0xb},{'field':_0x3629ab('0x13c'),'alias':_0x3629ab('0xd8'),'function':_0x3629ab('0x10f'),'ReportId':0xb},{'field':_0x3629ab('0xfe'),'alias':_0x3629ab('0xa6'),'function':_0x3629ab('0x10f'),'custom':0x1,'ReportId':0xb},{'field':_0x3629ab('0x58'),'alias':'Queue','groupBy':0x1,'ReportId':0xc},{'field':'queuecallerabandon','alias':_0x3629ab('0xc'),'function':_0x3629ab('0x10f'),'ReportId':0xc},{'field':_0x3629ab('0x21'),'alias':_0x3629ab('0xd5'),'custom':0x1,'ReportId':0xc},{'field':_0x3629ab('0x11f'),'alias':_0x3629ab('0x119'),'custom':0x1,'ReportId':0xc},{'field':_0x3629ab('0x12a'),'alias':_0x3629ab('0x14'),'custom':0x1,'ReportId':0xc},{'field':_0x3629ab('0x5e'),'alias':_0x3629ab('0xce'),'custom':0x1,'ReportId':0xc},{'field':_0x3629ab('0x51'),'alias':'Abandoned\x2060-120s','custom':0x1,'ReportId':0xc},{'field':'ROUND(COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20>=60\x20AND\x20UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20<120,1,NULL))\x20\x20\x20/\x20SUM(queuecallerabandon)\x20*100,1)','alias':'Abandoned\x20Rate\x2060-120s','custom':0x1,'ReportId':0xc},{'field':'COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20>=120,1,NULL))','alias':_0x3629ab('0x133'),'custom':0x1,'ReportId':0xc},{'field':_0x3629ab('0x5d'),'alias':_0x3629ab('0x16'),'custom':0x1,'ReportId':0xc},{'field':_0x3629ab('0x66'),'alias':_0x3629ab('0x95'),'format':_0x3629ab('0x13b'),'groupBy':0x1,'custom':0x1,'ReportId':0xd},{'field':_0x3629ab('0x116'),'alias':'Offered','function':_0x3629ab('0x131'),'ReportId':0xd},{'field':_0x3629ab('0x2e'),'alias':_0x3629ab('0x55'),'function':_0x3629ab('0x10f'),'ReportId':0xd},{'field':_0x3629ab('0x88'),'alias':'Abandoned','function':_0x3629ab('0x10f'),'custom':0x1,'ReportId':0xd},{'field':_0x3629ab('0x13c'),'alias':_0x3629ab('0x9a'),'function':'SUM','custom':0x1,'ReportId':0xd},{'field':_0x3629ab('0x8f'),'alias':_0x3629ab('0x8d'),'function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0xd},{'field':_0x3629ab('0x4a'),'alias':'AvgTalkTime','format':'SEC_TO_TIME','custom':0x1,'ReportId':0xd},{'field':_0x3629ab('0xa3'),'alias':_0x3629ab('0xc7'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0xd},{'field':_0x3629ab('0x66'),'alias':_0x3629ab('0xb8'),'format':'HOUR','groupBy':0x1,'custom':0x1,'ReportId':0xe},{'field':_0x3629ab('0x116'),'alias':_0x3629ab('0x3e'),'function':_0x3629ab('0x131'),'ReportId':0xe},{'field':_0x3629ab('0x2e'),'alias':_0x3629ab('0xc1'),'function':_0x3629ab('0x10f'),'ReportId':0xe},{'field':_0x3629ab('0x84'),'alias':_0x3629ab('0x11b'),'custom':0x1,'ReportId':0xe},{'field':_0x3629ab('0x88'),'alias':'Abandoned','function':_0x3629ab('0x10f'),'ReportId':0xe},{'field':_0x3629ab('0x13c'),'alias':_0x3629ab('0x9a'),'function':'SUM','ReportId':0xe},{'field':_0x3629ab('0x8f'),'alias':'Tot\x20TalkTime','function':_0x3629ab('0x10f'),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0xe},{'field':_0x3629ab('0x4a'),'alias':_0x3629ab('0xcc'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0xe},{'field':'ROUND(AVG(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)))','alias':_0x3629ab('0xc7'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0xe},{'field':'DAY(queuecallerjoinat)','alias':_0x3629ab('0x11c'),'groupBy':0x1,'custom':0x1,'ReportId':0xf},{'field':_0x3629ab('0x116'),'alias':_0x3629ab('0x3e'),'function':_0x3629ab('0x131'),'ReportId':0xf},{'field':_0x3629ab('0x2e'),'alias':_0x3629ab('0xc1'),'function':_0x3629ab('0x10f'),'ReportId':0xf},{'field':_0x3629ab('0x84'),'alias':_0x3629ab('0x11b'),'custom':0x1,'ReportId':0xf},{'field':_0x3629ab('0x88'),'alias':_0x3629ab('0x3d'),'function':_0x3629ab('0x10f'),'ReportId':0xf},{'field':_0x3629ab('0x13c'),'alias':_0x3629ab('0x9a'),'function':_0x3629ab('0x10f'),'ReportId':0xf},{'field':_0x3629ab('0x8f'),'alias':'Tot\x20TalkTime','function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0xf},{'field':'ROUND(AVG(UNIX_TIMESTAMP(queuecallercompleteAt)-UNIX_TIMESTAMP(queuecallerleaveAt)))','alias':'AvgTalkTime','format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0xf},{'field':'ROUND(AVG(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)))','alias':'AvgAbandonTime','format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0xf},{'field':_0x3629ab('0x25'),'alias':_0x3629ab('0x20'),'groupBy':0x1,'custom':0x1,'ReportId':0x10},{'field':_0x3629ab('0x116'),'alias':_0x3629ab('0x3e'),'function':_0x3629ab('0x131'),'ReportId':0x10},{'field':'queuecallercomplete','alias':_0x3629ab('0xc1'),'function':_0x3629ab('0x10f'),'ReportId':0x10},{'field':_0x3629ab('0x84'),'alias':'Answer\x20Rate','custom':0x1,'ReportId':0x10},{'field':'queuecallerabandon','alias':'Abandoned','function':'SUM','orderBy':'ASC','ReportId':0x10},{'field':_0x3629ab('0x13c'),'alias':_0x3629ab('0x9a'),'function':'SUM','ReportId':0x10},{'field':'UNIX_TIMESTAMP(queuecallercompleteAt)-UNIX_TIMESTAMP(queuecallerleaveAt)','alias':_0x3629ab('0x8d'),'function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x10},{'field':_0x3629ab('0x4a'),'alias':_0x3629ab('0xcc'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x10},{'field':'ROUND(AVG(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)))','alias':_0x3629ab('0xc7'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x10},{'field':'queue','alias':_0x3629ab('0x2d'),'groupBy':0x1,'ReportId':0x11},{'field':_0x3629ab('0x116'),'alias':_0x3629ab('0x3e'),'function':_0x3629ab('0x131'),'ReportId':0x11},{'field':_0x3629ab('0x2e'),'alias':'Answered','function':'SUM','ReportId':0x11},{'field':_0x3629ab('0x84'),'alias':_0x3629ab('0x11b'),'custom':0x1,'ReportId':0x11},{'field':_0x3629ab('0x88'),'alias':_0x3629ab('0x3d'),'function':_0x3629ab('0x10f'),'ReportId':0x11},{'field':_0x3629ab('0x13c'),'alias':'Unmanaged','function':'SUM','ReportId':0x11},{'field':_0x3629ab('0x8f'),'alias':_0x3629ab('0x8d'),'function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x11},{'field':_0x3629ab('0x4a'),'alias':_0x3629ab('0xcc'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x11},{'field':_0x3629ab('0xa3'),'alias':_0x3629ab('0xc7'),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0x11},{'field':_0x3629ab('0x116'),'alias':_0x3629ab('0x6e'),'ReportId':0x12},{'field':_0x3629ab('0x7d'),'alias':_0x3629ab('0x72'),'ReportId':0x12},{'field':'tag','alias':'Tag','ReportId':0x12},{'field':_0x3629ab('0x9b'),'alias':_0x3629ab('0x36'),'ReportId':0x12},{'field':'destination','alias':_0x3629ab('0x113'),'ReportId':0x12},{'field':_0x3629ab('0xc0'),'alias':_0x3629ab('0x111'),'ReportId':0x12},{'field':_0x3629ab('0x121'),'alias':'DestChannel','ReportId':0x12},{'field':_0x3629ab('0xb7'),'alias':_0x3629ab('0xb2'),'ReportId':0x12},{'field':'lastdata','alias':'LastData','ReportId':0x12},{'field':_0x3629ab('0x30'),'alias':_0x3629ab('0x125'),'ReportId':0x12},{'field':_0x3629ab('0xfd'),'alias':_0x3629ab('0x5f'),'ReportId':0x12},{'field':_0x3629ab('0x50'),'alias':_0x3629ab('0x68'),'ReportId':0x12},{'field':_0x3629ab('0xbb'),'alias':_0x3629ab('0xa0'),'ReportId':0x12},{'field':_0x3629ab('0xf3'),'alias':'Disposition','ReportId':0x12},{'field':_0x3629ab('0x116'),'alias':_0x3629ab('0x6e'),'ReportId':0x13},{'field':'accountcode','alias':_0x3629ab('0x29'),'ReportId':0x13},{'field':_0x3629ab('0x9b'),'alias':_0x3629ab('0x36'),'ReportId':0x13},{'field':'destination','alias':_0x3629ab('0x113'),'ReportId':0x13},{'field':_0x3629ab('0xc0'),'alias':_0x3629ab('0xa1'),'ReportId':0x13},{'field':_0x3629ab('0x30'),'alias':_0x3629ab('0x125'),'ReportId':0x13},{'field':_0x3629ab('0xfd'),'alias':_0x3629ab('0x5f'),'ReportId':0x13},{'field':'endtime','alias':_0x3629ab('0x68'),'ReportId':0x13},{'field':'duration','alias':'Duration','format':_0x3629ab('0xbf'),'ReportId':0x13},{'field':_0x3629ab('0x122'),'alias':'Billsec','format':_0x3629ab('0xbf'),'ReportId':0x13},{'field':_0x3629ab('0xf3'),'alias':'Disposition','ReportId':0x13},{'field':_0x3629ab('0xe2'),'alias':'Tag','ReportId':0x13},{'field':_0x3629ab('0x7d'),'alias':_0x3629ab('0x72'),'groupBy':0x1,'ReportId':0x14},{'field':'uniqueid','alias':_0x3629ab('0xd8'),'function':_0x3629ab('0x82'),'ReportId':0x14},{'field':_0x3629ab('0xbb'),'alias':_0x3629ab('0x9f'),'function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'ReportId':0x14},{'field':_0x3629ab('0xd2'),'alias':'Avg\x20Duration','format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x14},{'field':_0x3629ab('0xf3'),'alias':_0x3629ab('0x42'),'groupBy':0x1,'ReportId':0x15},{'field':_0x3629ab('0x116'),'alias':_0x3629ab('0xd8'),'function':'COUNT','ReportId':0x15},{'field':_0x3629ab('0xbb'),'alias':_0x3629ab('0x9f'),'function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'ReportId':0x15},{'field':_0x3629ab('0xd2'),'alias':_0x3629ab('0x112'),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0x15},{'field':_0x3629ab('0x126'),'alias':_0x3629ab('0x11e'),'groupBy':0x1,'custom':0x1,'ReportId':0x16},{'field':_0x3629ab('0x116'),'alias':_0x3629ab('0xd8'),'function':_0x3629ab('0x82'),'ReportId':0x16},{'field':_0x3629ab('0xbb'),'alias':'Tot\x20Duration','function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'ReportId':0x16},{'field':_0x3629ab('0xd2'),'alias':_0x3629ab('0x112'),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0x16},{'field':'starttime','alias':_0x3629ab('0x95'),'format':_0x3629ab('0x13b'),'groupBy':0x1,'ReportId':0x17},{'field':_0x3629ab('0x116'),'alias':_0x3629ab('0xd8'),'function':_0x3629ab('0x82'),'ReportId':0x17},{'field':_0x3629ab('0xbb'),'alias':_0x3629ab('0x9f'),'function':'SUM','format':'SEC_TO_TIME','ReportId':0x17},{'field':_0x3629ab('0xd2'),'alias':_0x3629ab('0x112'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x17},{'field':_0x3629ab('0x4f'),'alias':_0x3629ab('0x11e'),'groupBy':0x1,'orderBy':'ASC','ReportId':0x18},{'field':_0x3629ab('0x1d'),'alias':_0x3629ab('0xa0'),'function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x18},{'field':_0x3629ab('0x4f'),'alias':_0x3629ab('0x11e'),'groupBy':0x1,'ReportId':0x19},{'field':_0x3629ab('0xda'),'alias':_0x3629ab('0x8a'),'function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x19},{'field':'CASE\x20WHEN\x20type=\x27TALKING\x27\x20THEN\x20UNIX_TIMESTAMP(exitAt)-UNIX_TIMESTAMP(enterAt)\x20END','alias':_0x3629ab('0x61'),'function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x19},{'field':_0x3629ab('0x120'),'alias':_0x3629ab('0xca'),'function':'SUM','format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x19},{'field':_0x3629ab('0x4f'),'alias':_0x3629ab('0x11e'),'ReportId':0x1a},{'field':_0x3629ab('0xc9'),'alias':_0x3629ab('0x1b'),'ReportId':0x1a},{'field':_0x3629ab('0x53'),'alias':_0x3629ab('0x40'),'ReportId':0x1a},{'field':'data1','alias':_0x3629ab('0xa8'),'ReportId':0x1a},{'field':'duration','alias':_0x3629ab('0xa0'),'format':_0x3629ab('0xbf'),'ReportId':0x1a},{'field':_0x3629ab('0x4f'),'alias':_0x3629ab('0x11e'),'ReportId':0x1b},{'field':'interface','alias':_0x3629ab('0x128'),'ReportId':0x1b},{'field':_0x3629ab('0x7d'),'alias':_0x3629ab('0xf0'),'ReportId':0x1b},{'field':'data1','alias':_0x3629ab('0x72'),'ReportId':0x1b},{'field':_0x3629ab('0xc9'),'alias':'EnterAt','ReportId':0x1b},{'field':_0x3629ab('0x53'),'alias':_0x3629ab('0x40'),'ReportId':0x1b},{'field':_0x3629ab('0x1d'),'alias':_0x3629ab('0xa0'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x1b},{'field':_0x3629ab('0x4f'),'alias':_0x3629ab('0x11e'),'groupBy':0x1,'orderBy':_0x3629ab('0x33'),'ReportId':0x1c},{'field':_0x3629ab('0x56'),'alias':_0x3629ab('0x4c'),'groupBy':0x1,'orderBy':_0x3629ab('0x33'),'ReportId':0x1c},{'field':_0x3629ab('0x1d'),'alias':'Duration','function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x1c},{'field':_0x3629ab('0x79'),'alias':_0x3629ab('0xbc'),'ReportId':0x1d},{'field':'uniqueid','alias':_0x3629ab('0x100'),'ReportId':0x1d},{'field':'callerid','alias':_0x3629ab('0xa1'),'ReportId':0x1d},{'field':'dnid','alias':'DID','ReportId':0x1d},{'field':_0x3629ab('0x4d'),'alias':'Start\x20Time','orderBy':_0x3629ab('0x33'),'ReportId':0x1d},{'field':_0x3629ab('0x13'),'alias':_0x3629ab('0x114'),'ReportId':0x1d},{'field':_0x3629ab('0xf6'),'alias':_0x3629ab('0xa0'),'format':_0x3629ab('0xbf'),'custom':0x1,'ReportId':0x1d},{'field':_0x3629ab('0x116'),'alias':_0x3629ab('0x132'),'ReportId':0x1e},{'field':_0x3629ab('0x79'),'alias':_0x3629ab('0xbc'),'ReportId':0x1e},{'field':'callerid','alias':'Caller\x20Id','ReportId':0x1e},{'field':'node','alias':_0x3629ab('0x8c'),'ReportId':0x1e},{'field':_0x3629ab('0x74'),'alias':_0x3629ab('0x89'),'ReportId':0x1e},{'field':'connectedlinename','alias':_0x3629ab('0x11e'),'groupBy':0x1,'ReportId':0x1f},{'field':_0x3629ab('0x116'),'alias':_0x3629ab('0xe7'),'function':_0x3629ab('0x82'),'ReportId':0x1f},{'field':'rating','alias':'Total\x20Rating','function':_0x3629ab('0x10f'),'ReportId':0x1f},{'field':_0x3629ab('0xf4'),'alias':_0x3629ab('0x10c'),'function':_0x3629ab('0x3c'),'ReportId':0x1f},{'field':'queue','alias':'Queue','groupBy':0x1,'ReportId':0x20},{'field':_0x3629ab('0x116'),'alias':'Rated\x20Calls','function':_0x3629ab('0x82'),'ReportId':0x20},{'field':_0x3629ab('0xf4'),'alias':_0x3629ab('0x139'),'function':_0x3629ab('0x10f'),'ReportId':0x20},{'field':_0x3629ab('0xf4'),'alias':'Avg\x20Rating','function':_0x3629ab('0x3c'),'ReportId':0x20},{'field':'campaign','alias':_0x3629ab('0x2b'),'ReportId':0x21},{'field':_0x3629ab('0x4b'),'alias':_0x3629ab('0xb5'),'ReportId':0x21},{'field':_0x3629ab('0x30'),'alias':'LastCallAt','orderBy':_0x3629ab('0x98'),'ReportId':0x21},{'field':_0x3629ab('0x7e'),'alias':'State','ReportId':0x21},{'field':_0x3629ab('0x65'),'alias':_0x3629ab('0xe6'),'ReportId':0x21},{'field':'dropreason','alias':_0x3629ab('0x17'),'ReportId':0x21},{'field':_0x3629ab('0xb0'),'alias':_0x3629ab('0x10d'),'ReportId':0x21},{'field':_0x3629ab('0x4f'),'alias':_0x3629ab('0x11e'),'ReportId':0x21},{'field':'talktime','alias':'Talk\x20Time','ReportId':0x21},{'field':_0x3629ab('0xf3'),'alias':_0x3629ab('0x42'),'ReportId':0x21},{'field':_0x3629ab('0x116'),'alias':_0x3629ab('0x100'),'ReportId':0x21},{'field':'statedesc','alias':'State','groupBy':!![],'orderBy':_0x3629ab('0x33'),'ReportId':0x22},{'field':'id','alias':_0x3629ab('0xd8'),'function':_0x3629ab('0x82'),'ReportId':0x22},{'field':'ROUND(count(id)*100/(SELECT\x20COUNT(*)\x20FROM\x20cm_hopper_history\x20WHERE\x20campaigntype=\x27queue\x27),2)','alias':_0x3629ab('0xb'),'custom':!![],'ReportId':0x22},{'field':_0x3629ab('0xf8'),'alias':_0x3629ab('0x2b'),'orderBy':_0x3629ab('0x33'),'groupBy':!![],'ReportId':0x23},{'field':_0x3629ab('0x7e'),'alias':'State','groupBy':!![],'ReportId':0x23},{'field':'id','alias':_0x3629ab('0x12d'),'function':_0x3629ab('0x82'),'ReportId':0x23},{'field':_0x3629ab('0x28'),'groupBy':!![],'orderBy':_0x3629ab('0x33'),'ReportId':0x24},{'field':'id','alias':_0x3629ab('0x22'),'function':'COUNT','ReportId':0x24},{'field':_0x3629ab('0x70'),'alias':'Managed','custom':!![],'ReportId':0x24},{'field':_0x3629ab('0xb6'),'alias':_0x3629ab('0xf9'),'custom':!![],'ReportId':0x24},{'field':_0x3629ab('0x4f'),'alias':_0x3629ab('0x11e'),'groupBy':!![],'orderBy':'ASC','ReportId':0x25},{'field':'id','alias':_0x3629ab('0xd8'),'function':_0x3629ab('0x82'),'ReportId':0x25},{'field':_0x3629ab('0xaf'),'alias':'AVG\x20Talk\x20Time','custom':!![],'ReportId':0x25},{'field':'disposition','alias':_0x3629ab('0x42'),'groupBy':!![],'ReportId':0x26},{'field':'id','alias':_0x3629ab('0x9e'),'function':_0x3629ab('0x82'),'ReportId':0x26},{'field':_0x3629ab('0x10e'),'alias':_0x3629ab('0xe5'),'custom':!![],'ReportId':0x26},{'field':'membername','alias':_0x3629ab('0x11e'),'groupBy':!![],'ReportId':0x27},{'field':_0x3629ab('0xf3'),'alias':_0x3629ab('0x42'),'groupBy':!![],'ReportId':0x27},{'field':'id','alias':'Total','function':_0x3629ab('0x82'),'ReportId':0x27},{'field':_0x3629ab('0x10e'),'alias':'Total\x20(%)','custom':!![],'ReportId':0x27},{'field':'campaign','alias':'Campaign\x20Name','ReportId':0x28},{'field':_0x3629ab('0x4b'),'alias':_0x3629ab('0xb5'),'ReportId':0x28},{'field':_0x3629ab('0x30'),'alias':_0x3629ab('0x6d'),'orderBy':_0x3629ab('0x98'),'ReportId':0x28},{'field':_0x3629ab('0x7e'),'alias':'State','ReportId':0x28},{'field':_0x3629ab('0x65'),'alias':_0x3629ab('0xe6'),'ReportId':0x28},{'field':_0x3629ab('0x2'),'alias':_0x3629ab('0x17'),'ReportId':0x28},{'field':_0x3629ab('0xb0'),'alias':'BlackList','ReportId':0x28},{'field':_0x3629ab('0x35'),'alias':'Talk\x20Time','ReportId':0x28},{'field':_0x3629ab('0x116'),'alias':_0x3629ab('0x100'),'ReportId':0x28},{'field':'statedesc','alias':_0x3629ab('0xc3'),'groupBy':!![],'orderBy':_0x3629ab('0x33'),'ReportId':0x29},{'field':'id','alias':_0x3629ab('0xd8'),'function':_0x3629ab('0x82'),'ReportId':0x29},{'field':_0x3629ab('0xfa'),'alias':'Calls\x20(%)','custom':!![],'ReportId':0x29},{'field':_0x3629ab('0xf8'),'alias':_0x3629ab('0x2b'),'orderBy':_0x3629ab('0x33'),'groupBy':!![],'ReportId':0x2a},{'field':'statedesc','alias':_0x3629ab('0xc3'),'groupBy':!![],'ReportId':0x2a},{'field':'id','alias':_0x3629ab('0x12d'),'function':_0x3629ab('0x82'),'ReportId':0x2a},{'field':'ListId','groupBy':!![],'orderBy':_0x3629ab('0x33'),'ReportId':0x2b},{'field':'id','alias':_0x3629ab('0x22'),'function':'COUNT','ReportId':0x2b},{'field':_0x3629ab('0x70'),'alias':_0x3629ab('0x48'),'custom':!![],'ReportId':0x2b},{'field':'ROUND(SUM(IF(state=4,1,0))/COUNT(*)*100,1)','alias':'Penetration\x20Rate','custom':!![],'ReportId':0x2b},{'field':_0x3629ab('0x31'),'alias':_0x3629ab('0x38'),'groupBy':!![],'ReportId':0x2c},{'field':'chat_interactions.id','alias':_0x3629ab('0x138'),'function':_0x3629ab('0x82'),'ReportId':0x2c},{'field':_0x3629ab('0x6c'),'alias':_0x3629ab('0x80'),'custom':!![],'ReportId':0x2c},{'field':_0x3629ab('0xcb'),'alias':_0x3629ab('0x107'),'custom':!![],'ReportId':0x2c},{'field':_0x3629ab('0x1c'),'alias':_0x3629ab('0x9a'),'custom':!![],'ReportId':0x2c},{'field':_0x3629ab('0xe4'),'alias':_0x3629ab('0x3d'),'custom':!![],'ReportId':0x2c},{'field':_0x3629ab('0x31'),'alias':'Web\x20Site','groupBy':!![],'ReportId':0x2d},{'field':_0x3629ab('0xf2'),'alias':'Interaction\x20Time','function':'SUM','format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x2d},{'field':_0x3629ab('0x26'),'alias':_0x3629ab('0xec'),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x2d},{'field':_0x3629ab('0x102'),'alias':_0x3629ab('0x11e'),'groupBy':!![],'ReportId':0x2e},{'field':_0x3629ab('0xfb'),'alias':'Closed','function':'SUM','ReportId':0x2e},{'field':_0x3629ab('0xf2'),'alias':'Interaction\x20Time','function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x2e},{'field':_0x3629ab('0x26'),'alias':_0x3629ab('0xec'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x2e},{'field':_0x3629ab('0xa9'),'alias':'Date','format':_0x3629ab('0x13b'),'groupBy':!![],'custom':!![],'ReportId':0x2f},{'field':_0x3629ab('0xe0'),'alias':_0x3629ab('0x138'),'function':'COUNT','ReportId':0x2f},{'field':_0x3629ab('0xcb'),'alias':_0x3629ab('0x55'),'custom':!![],'ReportId':0x2f},{'field':_0x3629ab('0x46'),'alias':_0x3629ab('0x117'),'custom':!![],'ReportId':0x2f},{'field':_0x3629ab('0x1c'),'alias':_0x3629ab('0x9a'),'custom':!![],'ReportId':0x2f},{'field':_0x3629ab('0x108'),'alias':'Unmanaged\x20(%)','custom':!![],'ReportId':0x2f},{'field':'COUNT(IF(closed=1\x20&&\x20disposition\x20=\x27abandoned\x27,1,NULL))','alias':'Abandoned','custom':!![],'ReportId':0x2f},{'field':'ROUND(COUNT(IF(closed=1\x20&&\x20disposition=\x27abandoned\x27,1,NULL))/COUNT(id)\x20*100,1)','alias':_0x3629ab('0x7f'),'custom':!![],'ReportId':0x2f},{'field':'UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)','alias':'Interaction\x20Time','function':'SUM','format':'SEC_TO_TIME','custom':!![],'ReportId':0x2f},{'field':'ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)))','alias':_0x3629ab('0xec'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x2f},{'field':_0x3629ab('0xf5'),'alias':_0x3629ab('0x2d'),'groupBy':!![],'ReportId':0x30},{'field':_0x3629ab('0x13a'),'alias':_0x3629ab('0x138'),'function':'COUNT','ReportId':0x30},{'field':'COUNT(IF(reason=\x27accepted\x27,1,NULL))','alias':_0x3629ab('0xc6'),'custom':!![],'ReportId':0x30},{'field':'COUNT(IF(reason=\x27timeout\x27,1,NULL))','alias':_0x3629ab('0xc4'),'custom':!![],'ReportId':0x30},{'field':_0x3629ab('0xf6'),'alias':'Hold\x20Time','function':'SUM','format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x30},{'field':_0x3629ab('0xb4'),'alias':_0x3629ab('0xaa'),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x30},{'field':_0x3629ab('0x10a'),'alias':'Email\x20Account','groupBy':!![],'ReportId':0x31},{'field':_0x3629ab('0x81'),'alias':'Interactions','function':_0x3629ab('0x82'),'ReportId':0x31},{'field':_0x3629ab('0x6c'),'alias':_0x3629ab('0x80'),'custom':!![],'ReportId':0x31},{'field':'COUNT(IF(closed=1,1,NULL))','alias':_0x3629ab('0x107'),'custom':!![],'ReportId':0x31},{'field':'mail_accounts.name','alias':_0x3629ab('0x5b'),'groupBy':!![],'ReportId':0x32},{'field':_0x3629ab('0xf1'),'alias':'Interaction\x20Time','function':'SUM','format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x32},{'field':_0x3629ab('0x63'),'alias':'AVG\x20Interaction\x20Time','format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x32},{'field':'users.fullname','alias':'Agent','groupBy':!![],'ReportId':0x33},{'field':_0x3629ab('0x106'),'alias':_0x3629ab('0x107'),'function':_0x3629ab('0x10f'),'ReportId':0x33},{'field':'UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(mail_interactions.createdAt)','alias':_0x3629ab('0xbe'),'function':_0x3629ab('0x10f'),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x33},{'field':_0x3629ab('0x63'),'alias':_0x3629ab('0xec'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x33},{'field':_0x3629ab('0x7a'),'alias':'Date','format':'DATE','groupBy':!![],'custom':!![],'ReportId':0x34},{'field':'mail_interactions.id','alias':_0x3629ab('0x138'),'function':'COUNT','ReportId':0x34},{'field':_0x3629ab('0x99'),'alias':_0x3629ab('0x55'),'custom':!![],'ReportId':0x34},{'field':_0x3629ab('0x76'),'alias':_0x3629ab('0x117'),'custom':!![],'ReportId':0x34},{'field':_0x3629ab('0x105'),'alias':'Interaction\x20Time','function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x34},{'field':_0x3629ab('0xe3'),'alias':_0x3629ab('0xec'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x34},{'field':_0x3629ab('0x94'),'alias':'Queue','groupBy':!![],'ReportId':0x35},{'field':_0x3629ab('0x10'),'alias':'Interactions','function':_0x3629ab('0x82'),'ReportId':0x35},{'field':_0x3629ab('0xf7'),'alias':_0x3629ab('0xc6'),'custom':!![],'ReportId':0x35},{'field':_0x3629ab('0x118'),'alias':'Timeout','custom':!![],'ReportId':0x35},{'field':_0x3629ab('0xf6'),'alias':_0x3629ab('0x8'),'function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x35},{'field':_0x3629ab('0xb4'),'alias':_0x3629ab('0xaa'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x35},{'field':_0x3629ab('0x1f'),'alias':_0x3629ab('0x27'),'groupBy':!![],'ReportId':0x36},{'field':_0x3629ab('0xb9'),'alias':_0x3629ab('0x138'),'function':_0x3629ab('0x82'),'ReportId':0x36},{'field':_0x3629ab('0x6c'),'alias':_0x3629ab('0x80'),'custom':!![],'ReportId':0x36},{'field':_0x3629ab('0x99'),'alias':'Closed','custom':!![],'ReportId':0x36},{'field':_0x3629ab('0x1f'),'alias':_0x3629ab('0x27'),'groupBy':!![],'ReportId':0x37},{'field':'UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(openchannel_interactions.createdAt)','alias':_0x3629ab('0xbe'),'function':'SUM','format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x37},{'field':'ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(openchannel_interactions.createdAt)))','alias':'AVG\x20Interaction\x20Time','format':'SEC_TO_TIME','custom':!![],'ReportId':0x37},{'field':_0x3629ab('0x102'),'alias':_0x3629ab('0x11e'),'groupBy':!![],'ReportId':0x38},{'field':_0x3629ab('0x123'),'alias':'Closed','function':_0x3629ab('0x10f'),'ReportId':0x38},{'field':_0x3629ab('0x45'),'alias':_0x3629ab('0xbe'),'function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x38},{'field':'ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(openchannel_interactions.createdAt)))','alias':_0x3629ab('0xec'),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x38},{'field':'openchannel_interactions.createdAt','alias':_0x3629ab('0x95'),'format':_0x3629ab('0x13b'),'groupBy':!![],'custom':!![],'ReportId':0x39},{'field':_0x3629ab('0xb9'),'alias':'Interactions','function':_0x3629ab('0x82'),'ReportId':0x39},{'field':_0x3629ab('0x99'),'alias':_0x3629ab('0x55'),'custom':!![],'ReportId':0x39},{'field':_0x3629ab('0x76'),'alias':_0x3629ab('0x117'),'custom':!![],'ReportId':0x39},{'field':_0x3629ab('0x105'),'alias':'Interaction\x20Time','function':'SUM','format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x39},{'field':_0x3629ab('0xe3'),'alias':_0x3629ab('0xec'),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x39},{'field':_0x3629ab('0x11'),'alias':'Queue','groupBy':!![],'ReportId':0x3a},{'field':_0x3629ab('0x9d'),'alias':_0x3629ab('0x138'),'function':'COUNT','ReportId':0x3a},{'field':_0x3629ab('0xf7'),'alias':'Accepted','custom':!![],'ReportId':0x3a},{'field':_0x3629ab('0x118'),'alias':_0x3629ab('0xc4'),'custom':!![],'ReportId':0x3a},{'field':'UNIX_TIMESTAMP(leaveAt)-UNIX_TIMESTAMP(joinAt)','alias':_0x3629ab('0x8'),'function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x3a},{'field':'ROUND(AVG(UNIX_TIMESTAMP(leaveAt)-UNIX_TIMESTAMP(joinAt)))','alias':_0x3629ab('0xaa'),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x3a},{'field':_0x3629ab('0xac'),'alias':_0x3629ab('0xe9'),'groupBy':!![],'ReportId':0x3b},{'field':_0x3629ab('0x136'),'alias':_0x3629ab('0x138'),'function':_0x3629ab('0x82'),'ReportId':0x3b},{'field':_0x3629ab('0x6c'),'alias':_0x3629ab('0x80'),'custom':!![],'ReportId':0x3b},{'field':_0x3629ab('0x99'),'alias':'Closed','custom':!![],'ReportId':0x3b},{'field':_0x3629ab('0xac'),'alias':_0x3629ab('0xe9'),'groupBy':!![],'ReportId':0x3c},{'field':_0x3629ab('0x6f'),'alias':_0x3629ab('0xbe'),'function':'SUM','format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x3c},{'field':_0x3629ab('0x127'),'alias':_0x3629ab('0xec'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x3c},{'field':'users.fullname','alias':'Agent','groupBy':!![],'ReportId':0x3d},{'field':'sms_interactions.closed','alias':_0x3629ab('0x107'),'function':_0x3629ab('0x10f'),'ReportId':0x3d},{'field':_0x3629ab('0x6f'),'alias':_0x3629ab('0xbe'),'function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x3d},{'field':'ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(sms_interactions.createdAt)))','alias':_0x3629ab('0xec'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x3d},{'field':_0x3629ab('0xd7'),'alias':_0x3629ab('0x95'),'format':_0x3629ab('0x13b'),'groupBy':!![],'custom':!![],'ReportId':0x3e},{'field':'sms_interactions.id','alias':'Interactions','function':'COUNT','ReportId':0x3e},{'field':_0x3629ab('0x99'),'alias':'Completed','custom':!![],'ReportId':0x3e},{'field':_0x3629ab('0x76'),'alias':'Completed\x20(%)','custom':!![],'ReportId':0x3e},{'field':_0x3629ab('0x105'),'alias':_0x3629ab('0xbe'),'function':'SUM','format':'SEC_TO_TIME','custom':!![],'ReportId':0x3e},{'field':_0x3629ab('0xe3'),'alias':_0x3629ab('0xec'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x3e},{'field':_0x3629ab('0x134'),'alias':'Queue','groupBy':!![],'ReportId':0x3f},{'field':_0x3629ab('0xbd'),'alias':'Interactions','function':_0x3629ab('0x82'),'ReportId':0x3f},{'field':'COUNT(IF(reason=\x27accepted\x27,1,NULL))','alias':_0x3629ab('0xc6'),'custom':!![],'ReportId':0x3f},{'field':_0x3629ab('0x118'),'alias':_0x3629ab('0xc4'),'custom':!![],'ReportId':0x3f},{'field':_0x3629ab('0xf6'),'alias':_0x3629ab('0x8'),'function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x3f},{'field':_0x3629ab('0xb4'),'alias':_0x3629ab('0xaa'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x3f},{'field':_0x3629ab('0x124'),'alias':'Queue','groupBy':!![],'ReportId':0x44},{'field':_0x3629ab('0xd1'),'alias':_0x3629ab('0x138'),'function':_0x3629ab('0x82'),'ReportId':0x44},{'field':_0x3629ab('0xf7'),'alias':_0x3629ab('0xc6'),'custom':!![],'ReportId':0x44},{'field':'COUNT(IF(reason=\x27timeout\x27,1,NULL))','alias':_0x3629ab('0xc4'),'custom':!![],'ReportId':0x44},{'field':_0x3629ab('0xf6'),'alias':'Hold\x20Time','function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x44},{'field':_0x3629ab('0xb4'),'alias':_0x3629ab('0xaa'),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x44},{'field':_0x3629ab('0x137'),'alias':'Date','format':_0x3629ab('0x13b'),'groupBy':!![],'custom':!![],'ReportId':0x43},{'field':_0x3629ab('0x37'),'alias':'Interactions','function':_0x3629ab('0x82'),'ReportId':0x43},{'field':_0x3629ab('0x99'),'alias':_0x3629ab('0x55'),'custom':!![],'ReportId':0x43},{'field':'ROUND(COUNT(IF(closed=1,1,NULL))/COUNT(id)\x20*100,1)','alias':_0x3629ab('0x117'),'custom':!![],'ReportId':0x43},{'field':'UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)','alias':'Interaction\x20Time','function':'SUM','format':'SEC_TO_TIME','custom':!![],'ReportId':0x43},{'field':'ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)))','alias':'AVG\x20Interaction\x20Time','format':'SEC_TO_TIME','custom':!![],'ReportId':0x43},{'field':_0x3629ab('0x102'),'alias':_0x3629ab('0x11e'),'groupBy':!![],'ReportId':0x42},{'field':'fax_interactions.closed','alias':_0x3629ab('0x107'),'function':'SUM','ReportId':0x42},{'field':_0x3629ab('0x15'),'alias':'Interaction\x20Time','function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x42},{'field':_0x3629ab('0xe'),'alias':_0x3629ab('0xec'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x42},{'field':_0x3629ab('0x93'),'alias':_0x3629ab('0xb1'),'groupBy':!![],'ReportId':0x41},{'field':_0x3629ab('0x15'),'alias':_0x3629ab('0xbe'),'function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x41},{'field':_0x3629ab('0xe'),'alias':_0x3629ab('0xec'),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x41},{'field':_0x3629ab('0x93'),'alias':_0x3629ab('0xb1'),'groupBy':!![],'ReportId':0x40},{'field':_0x3629ab('0x37'),'alias':_0x3629ab('0x138'),'function':'COUNT','ReportId':0x40},{'field':_0x3629ab('0x6c'),'alias':_0x3629ab('0x80'),'custom':!![],'ReportId':0x40},{'field':_0x3629ab('0x99'),'alias':_0x3629ab('0x107'),'custom':!![],'ReportId':0x40},{'field':_0x3629ab('0x130'),'alias':_0x3629ab('0xd6'),'groupBy':!![],'custom':![],'ReportId':0x4a},{'field':'users.fullname','alias':_0x3629ab('0x115'),'groupBy':![],'custom':![],'ReportId':0x4a},{'field':_0x3629ab('0x101'),'alias':'POSITIVE','groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x3629ab('0xab'),'alias':'NEGATIVE','groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x3629ab('0xad'),'alias':_0x3629ab('0x1a'),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':'COUNT\x20(IF(voice_recordings.sentiment\x20=\x20\x27MIXED\x27,1,NULL))','alias':_0x3629ab('0x90'),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x3629ab('0x19'),'alias':'TOT','function':_0x3629ab('0x82'),'groupBy':![],'custom':![],'ReportId':0x4a},{'field':_0x3629ab('0xeb'),'alias':_0x3629ab('0x85'),'groupBy':![],'custom':!![],'ReportId':0x45},{'field':_0x3629ab('0xc2'),'alias':_0x3629ab('0xd4'),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x3629ab('0x78'),'alias':_0x3629ab('0x87'),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x3629ab('0xb3'),'alias':_0x3629ab('0xdf'),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x3629ab('0x19'),'alias':_0x3629ab('0x69'),'function':_0x3629ab('0x82'),'groupBy':![],'custom':![],'ReportId':0x4b},{'field':_0x3629ab('0x101'),'alias':_0x3629ab('0x49'),'groupBy':![],'custom':!![],'ReportId':0x4b},{'field':'COUNT\x20(IF(voice_recordings.sentiment\x20=\x20\x27NEGATIVE\x27,1,NULL))','alias':_0x3629ab('0x103'),'groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x3629ab('0xad'),'alias':_0x3629ab('0x1a'),'groupBy':![],'custom':!![],'ReportId':0x4b},{'field':'COUNT\x20(IF(voice_recordings.sentiment\x20=\x20\x27MIXED\x27,1,NULL))','alias':_0x3629ab('0x90'),'groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x3629ab('0xeb'),'alias':'Positive(%)','groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x3629ab('0xc2'),'alias':_0x3629ab('0xd4'),'groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x3629ab('0x78'),'alias':_0x3629ab('0x87'),'groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x3629ab('0xb3'),'alias':_0x3629ab('0xdf'),'groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x3629ab('0x3a'),'alias':_0x3629ab('0x12c'),'groupBy':!![],'ReportId':0x45},{'field':_0x3629ab('0x96'),'alias':_0x3629ab('0x138'),'function':_0x3629ab('0x82'),'ReportId':0x45},{'field':_0x3629ab('0x6c'),'alias':_0x3629ab('0x80'),'custom':!![],'ReportId':0x45},{'field':'COUNT(IF(closed=1,1,NULL))','alias':_0x3629ab('0x107'),'custom':!![],'ReportId':0x45},{'field':_0x3629ab('0x3a'),'alias':'Whatsapp\x20Account','groupBy':!![],'ReportId':0x46},{'field':_0x3629ab('0xe8'),'alias':'Interaction\x20Time','function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x46},{'field':_0x3629ab('0x57'),'alias':_0x3629ab('0xec'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x46},{'field':_0x3629ab('0x102'),'alias':_0x3629ab('0x11e'),'groupBy':!![],'ReportId':0x47},{'field':_0x3629ab('0x109'),'alias':_0x3629ab('0x107'),'function':'SUM','ReportId':0x47},{'field':_0x3629ab('0xe8'),'alias':_0x3629ab('0xbe'),'function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x47},{'field':_0x3629ab('0x57'),'alias':_0x3629ab('0xec'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x47},{'field':_0x3629ab('0x10b'),'alias':'Date','format':_0x3629ab('0x13b'),'groupBy':!![],'custom':!![],'ReportId':0x48},{'field':_0x3629ab('0x96'),'alias':_0x3629ab('0x138'),'function':_0x3629ab('0x82'),'ReportId':0x48},{'field':_0x3629ab('0x99'),'alias':_0x3629ab('0x55'),'custom':!![],'ReportId':0x48},{'field':_0x3629ab('0x76'),'alias':'Completed\x20(%)','custom':!![],'ReportId':0x48},{'field':_0x3629ab('0x105'),'alias':_0x3629ab('0xbe'),'function':'SUM','format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x48},{'field':_0x3629ab('0xe3'),'alias':_0x3629ab('0xec'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x48},{'field':_0x3629ab('0xee'),'alias':'Queue','groupBy':!![],'ReportId':0x49},{'field':_0x3629ab('0x86'),'alias':_0x3629ab('0x138'),'function':_0x3629ab('0x82'),'ReportId':0x49},{'field':'COUNT(IF(reason=\x27accepted\x27,1,NULL))','alias':_0x3629ab('0xc6'),'custom':!![],'ReportId':0x49},{'field':_0x3629ab('0x118'),'alias':'Timeout','custom':!![],'ReportId':0x49},{'field':_0x3629ab('0xf6'),'alias':_0x3629ab('0x8'),'function':_0x3629ab('0x10f'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x49},{'field':_0x3629ab('0xb4'),'alias':_0x3629ab('0xaa'),'format':_0x3629ab('0xbf'),'custom':!![],'ReportId':0x49}];return _[_0x3629ab('0x8e')](_0x10c877,_0x3629ab('0x52'));};
\ No newline at end of file
+const a869_0x296b=['AVG\x20Interaction\x20Time','Abandoned\x20Rate>120s','Offered','Destination','COUNT(IF(closed=1\x20&&\x20disposition\x20=\x27unmanaged\x27,1,NULL))','Hold\x20Time','Drop\x20Reason','CallerID','openchannel_interactions.id','data1','queuecallerabandonAt','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(sms_interactions.createdAt)','queuecallerexit','blacklist','whatsapp_queues.name','talktime','COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20>=10\x20AND\x20UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20<60,1,NULL))','rating','interface','COUNT\x20(IF(voice_recordings.sentiment\x20=\x20\x27NEUTRAL\x27,1,NULL))','fax_interactions.id','TotTalkTime','JoinAt','CASE\x20WHEN\x20queuecallercomplete=1\x20THEN\x20\x27YES\x27\x20ELSE\x20\x27NO\x27\x20END','Rated\x20Calls','ROUND(COUNT(IF(holdtime\x20>=30,1,NULL))\x20/\x20SUM(agentcomplete)\x20*100,1)','ROUND(COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20>=120,1,NULL))\x20\x20/\x20SUM(queuecallerabandon)\x20*100,1)','lastdata','fax_interactions.createdAt','membername','accountcode','CASE\x20WHEN\x20queuecallercomplete=1\x20THEN\x20queuecallercompleteAt\x20ELSE\x20queuecallerLeaveAt\x20END','report_mail_queue.id','ROUND(COUNT(id)*100/(SELECT\x20COUNT(*)\x20FROM\x20cm_hopper_final\x20WHERE\x20state=4\x20and\x20campaigntype=\x27queue\x27),2)','CONCAT(ROUND((\x20(SELECT\x20COUNT(IF(voice_recordings.sentiment\x20=\x20\x27MIXED\x27,1,NULL)))*100/\x20COUNT\x20(voice_recordings.sentiment)),2),\x27%\x27)','Positive(%)','COUNT(IF(reason=\x27accepted\x27,1,NULL))','COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20<10,1,NULL))','report_sms_queue.id','starttime','State','queuecallerjoinat','chat_interactions.closed','Abandon','UNIX_TIMESTAMP(queuecallerExitAt)-UNIX_TIMESTAMP(queuecallerjoinAt)','ASC','Accepted','node','whatsapp_interactions.id','report_chat_queue.id','ListId','DATE','COUNT(IF(closed=1\x20&&\x20((disposition\x20!=\x27unmanaged\x27\x20&&\x20disposition\x20!=\x27abandoned\x27)\x20||\x20disposition\x20IS\x20NULL),1,NULL))','voice_recordings.sentiment','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(mail_interactions.createdAt)))','sms_interactions.id','agentcalledAt','CallerId','agentcomplete','AgentComplete','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(fax_interactions.createdAt)))','ROUND(AVG(UNIX_TIMESTAMP(leaveAt)-UNIX_TIMESTAMP(joinAt)))','uniqueid','queuecallerabandon','talktime\x20+\x20acwtime','Abandon\x20Time','ROUND(SUM(talktime\x20+\x20acwtime)/COUNT(agentcomplete))','CASE\x20WHEN\x20type=\x27LOGIN\x27\x20THEN\x20UNIX_TIMESTAMP(exitAt)-UNIX_TIMESTAMP(enterAt)\x20END','whatsapp_interactions.closed','Answered\x20>30s','Global\x20Count','position','users.fullname','CONCAT(ROUND((\x20(SELECT\x20COUNT(IF(voice_recordings.sentiment\x20=\x20\x27NEGATIVE\x27,1,NULL)))*100/\x20COUNT\x20(voice_recordings.sentiment)),2),\x27%\x27)','AVG','Abandoned\x2060-120s','Openchannel\x20Account','DID','AbandonAt','Tot\x20Answered','Mixed(%)','tag','Fax\x20Account','source','Open','whatsapp_accounts.name','billableseconds','disposition','lastapplication','UNIX_TIMESTAMP(leaveAt)-UNIX_TIMESTAMP(joinAt)','SUM','agentconnectAt','StartTime','Closed','Date','queuecallerleaveAt','EndTime','DayOfWeek','COUNT\x20DISTINCT','NEUTRAL','Sms\x20Account','AVG\x20Talk\x20Time','sms_interactions.createdAt','connectedlinename','ROUND(AVG(acwtime))','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(chat_interactions.createdAt)))','CASE\x20WHEN\x20type=\x27PAUSE\x27\x20THEN\x20UNIX_TIMESTAMP(exitAt)-UNIX_TIMESTAMP(enterAt)\x20END','Event','Campaign\x20Name','Tot\x20Duration','TotHandleTime','statedesc','COUNT','COUNT\x20(IF(voice_recordings.sentiment\x20=\x20\x27MIXED\x27,1,NULL))','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)','BlackList','queuecallerexitreason','AgentACWTime','Pause\x20Time','Avg\x20Rating','Whatsapp\x20Account','QueueAbandonAt','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(sms_interactions.createdAt)))','QueueExit','LastApp','queuecallerjoinAt','HOUR','DESC','ROUND(SUM(queuecallercomplete)/COUNT(DISTINCT\x20uniqueid)*100,1)','LastData','LastCallAt','SUBSTRING_INDEX(channel,\x20\x22-\x22,\x201)','End\x20Time','Answered\x2020-30s','SEC_TO_TIME(AVG(talktime))','COUNT(IF(closed=1\x20&&\x20disposition\x20=\x27abandoned\x27,1,NULL))','Calls','ROUND(COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20<10,1,NULL))\x20/\x20SUM(queuecallerabandon)\x20*100,1)','queuecallercomplete','Abandoned','leaveAt','calleridname','openchannel_interactions.closed','exitAt','Penetration\x20Rate','sms_queues.name','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(whatsapp_interactions.createdAt)))','Data','Abandoned\x2010-60s','Answer\x20Rate\x2020-30s','Day','Calls\x20(%)','ROUND(AVG(duration))','Unmanaged','Tot\x20TalkTime','fax_interactions.closed','Complete','chat_interactions.id','CallerIdName','EnterAt','whatsapp_interactions.createdAt','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(fax_interactions.createdAt)','Avg\x20TalkTime','Disposition','Timeout','CONCAT(ROUND((\x20(SELECT\x20COUNT(IF(voice_recordings.sentiment\x20=\x20\x27NEUTRAL\x27,1,NULL)))*100/\x20COUNT\x20(voice_recordings.sentiment)),2),\x27%\x27)','TOT','Completed\x20(%)','ROUND(COUNT(IF(holdtime\x20>=10\x20AND\x20holdtime\x20<20,1,NULL))\x20/\x20SUM(agentcomplete)\x20*100,1)','IF(queuecallercomplete=1,holdtime,null)','data','TalkTime','ROUND(SUM(IF(state=4,1,0))/COUNT(*)*100,1)','AgentConnectAt','exten','openchannel_interactions.createdAt','report_fax_queue.id','Interactions','QueueExitAt','MIXED','Answer\x20Rate\x2010-20s','AVG\x20Hold\x20Time','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)))','Type','COUNT(IF(holdtime\x20>=30,1,NULL))','ROUND(COUNT(IF(closed=1,1,NULL))/COUNT(id)\x20*100,1)','lastevent','ROUND(COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20>=60\x20AND\x20UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20<120,1,NULL))\x20\x20\x20/\x20SUM(queuecallerabandon)\x20*100,1)','ROUND(AVG(UNIX_TIMESTAMP(queuecallerExitAt)-UNIX_TIMESTAMP(queuecallerjoinAt)))','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(chat_interactions.createdAt)','COUNT(IF(holdtime\x20>=10\x20AND\x20holdtime\x20<20,1,NULL))','calleridnum','POSITIVE','countglobal','Agent','Managed','DAYNAME(queuecallerjoinat)','chat_queues.name','ROUND(COUNT(IF(closed=1\x20&&\x20disposition=\x27unmanaged\x27,1,NULL))/COUNT(id)\x20*100,1)','answertime','NEGATIVE','SEC_TO_TIME','dropreason','CONCAT(ROUND((\x20(SELECT\x20COUNT(IF(voice_recordings.sentiment\x20=\x20\x27POSITIVE\x27,1,NULL)))*100/\x20COUNT\x20(voice_recordings.sentiment)),2),\x27%\x27)','reason','Login\x20Time','Abandoned\x20(%)','SUM(IF(state=4,1,0))','Abandoned<10s','voice_recordings.UserId','AgentExtension','ROUND(AVG(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)))','agentcompleteAt','COUNT\x20(IF(voice_recordings.sentiment\x20=\x20\x27NEGATIVE\x27,1,NULL))','mail_queues.name','queue','Abandoned>120s','Total\x20Calls','Recorded\x20Calls','ROUND(count(id)*100/(SELECT\x20COUNT(*)\x20FROM\x20cm_hopper_history\x20WHERE\x20campaigntype=\x27ivr\x27),2)','Reason','ROUND(AVG(talktime))','exports','acwtime','Answer\x20Rate\x20>30s','COUNT(IF(reason=\x27timeout\x27,1,NULL))','holdtime','LastEvent','AvgAbandonTime','CallerIdNum','Tag','mail_interactions.id','report_openchannel_queue.id','campaign','destination','Avg\x20Duration','COUNT(IF(holdtime<10,1,NULL))','mail_accounts.name','Email\x20Account','AvgACWTime','Unmanaged\x20(%)','AnswerTime','queuecallercompleteAt','ROUND(COUNT(IF(closed=1\x20&&\x20((disposition\x20!=\x27unmanaged\x27\x20&&\x20disposition\x20!=\x27abandoned\x27)\x20||\x20disposition\x20IS\x20NULL),1,NULL))/COUNT(id)\x20*100,1)','callerid','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(mail_interactions.createdAt)','CompleteAt','Answer\x20Rate\x20<10s','UniqueId','Web\x20Site','Tot\x20Handle\x20Time','ReportId','Avg\x20HoldTime','ROUND(COUNT(IF(closed=1\x20&&\x20disposition=\x27abandoned\x27,1,NULL))/COUNT(id)\x20*100,1)','UNIX_TIMESTAMP(exitAt)-UNIX_TIMESTAMP(enterAt)','chat_interactions.createdAt','Duration','AgentACW','Source','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(openchannel_interactions.createdAt)))','endtime','COUNT(IF(closed=0,1,NULL))','Answer\x20Rate','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(whatsapp_interactions.createdAt)','sms_accounts.name','agentacw','Answered\x20<10s','Abandoned\x20Rate<10s','mail_interactions.createdAt','Tot\x20ACWTime','Answered','dnid','Unique\x20Id','Full\x20Name','PauseType','UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)','COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20>=120,1,NULL))','Completed','chat_websites.name','UNIX_TIMESTAMP(queuecallercompleteAt)-UNIX_TIMESTAMP(queuecallerleaveAt)','Total\x20(%)','COUNT(IF(holdtime\x20>=20\x20AND\x20holdtime\x20<30,1,NULL))','Neutral(%)','Interaction\x20Time','Project\x20Name','Total','ROUND(count(id)*100/(SELECT\x20COUNT(*)\x20FROM\x20cm_hopper_history\x20WHERE\x20campaigntype=\x27queue\x27),2)','Total\x20Rating','project_name','ROUND(AVG(UNIX_TIMESTAMP(queuecallercompleteAt)-UNIX_TIMESTAMP(queuecallerleaveAt)))','COUNT\x20(IF(voice_recordings.sentiment\x20=\x20\x27POSITIVE\x27,1,NULL))','type','UnmanagedReason','Hour','AvgTalkTime','UserId','HangupReason','AbandonTime','Interface','Talk\x20Time','fax_accounts.name','queuecallerexitAt','ExitAt','duration','Tot\x20Unmanaged\x20Time','Block','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(openchannel_interactions.createdAt)','Queue','QueueLeaveAt','destinationchannel','COUNT(IF(closed=1,1,NULL))','ROUND(COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20>=10\x20AND\x20UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20<60,1,NULL))\x20\x20/\x20SUM(queuecallerabandon)\x20*100,1)','Negative(%)','DestChannel','enterAt','mail_interactions.closed'];(function(_0xc36a06,_0x296b48){const _0x1a7020=function(_0x155569){while(--_0x155569){_0xc36a06['push'](_0xc36a06['shift']());}};_0x1a7020(++_0x296b48);}(a869_0x296b,0x1a2));const a869_0x1a70=function(_0xc36a06,_0x296b48){_0xc36a06=_0xc36a06-0x0;let _0x1a7020=a869_0x296b[_0xc36a06];return _0x1a7020;};const _0x1866b8=a869_0x1a70;'use strict';const _=require('lodash');module[_0x1866b8('0x78')]=function(){const _0x577ef0=_0x1866b8,_0x155569=[{'field':_0x577ef0('0x114'),'alias':'UniqueId','ReportId':0x1},{'field':_0x577ef0('0x59'),'alias':_0x577ef0('0x7f'),'ReportId':0x1},{'field':_0x577ef0('0x27'),'alias':_0x577ef0('0x38'),'ReportId':0x1},{'field':_0x577ef0('0x71'),'alias':_0x577ef0('0xcd'),'ReportId':0x1},{'field':_0x577ef0('0x17'),'alias':'QueueJoinAt','ReportId':0x1},{'field':_0x577ef0('0x135'),'alias':_0x577ef0('0xce'),'ReportId':0x1},{'field':_0x577ef0('0x115'),'alias':'QueueAbandon','ReportId':0x1},{'field':_0x577ef0('0xe0'),'alias':_0x577ef0('0x13'),'ReportId':0x1},{'field':'queuecallercomplete','alias':_0x577ef0('0x36'),'ReportId':0x1},{'field':_0x577ef0('0x8c'),'alias':_0x577ef0('0x90'),'ReportId':0x1},{'field':_0x577ef0('0xe2'),'alias':_0x577ef0('0x15'),'ReportId':0x1},{'field':_0x577ef0('0xc7'),'alias':_0x577ef0('0x4c'),'ReportId':0x1},{'field':_0x577ef0('0xe'),'alias':'QueueExitReason','ReportId':0x1},{'field':_0x577ef0('0x48'),'alias':_0x577ef0('0x123'),'ReportId':0x1},{'field':_0x577ef0('0xb1'),'alias':_0x577ef0('0x45'),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0x1},{'field':_0x577ef0('0xad'),'alias':_0x577ef0('0xc3'),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0x1},{'field':_0x577ef0('0x43'),'alias':_0x577ef0('0x8b'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x1},{'field':'calleridnum','alias':'CallerID','ReportId':0x2},{'field':_0x577ef0('0x71'),'alias':_0x577ef0('0xcd'),'ReportId':0x2},{'field':'queuecallerjoinAt','alias':_0x577ef0('0x132'),'ReportId':0x2},{'field':_0x577ef0('0xf5'),'alias':_0x577ef0('0x136'),'custom':0x1,'ReportId':0x2},{'field':_0x577ef0('0x7c'),'alias':'HoldTime','format':_0x577ef0('0x63'),'ReportId':0x2},{'field':_0x577ef0('0xed'),'alias':_0x577ef0('0xa8'),'custom':0x1,'ReportId':0x2},{'field':_0x577ef0('0x114'),'alias':_0x577ef0('0x92'),'ReportId':0x3},{'field':_0x577ef0('0x59'),'alias':'CallerIdNum','ReportId':0x3},{'field':'calleridname','alias':_0x577ef0('0x38'),'ReportId':0x3},{'field':_0x577ef0('0x71'),'alias':'Queue','ReportId':0x3},{'field':_0x577ef0('0xf3'),'alias':_0x577ef0('0x5c'),'ReportId':0x3},{'field':_0x577ef0('0x10e'),'alias':'AgentCalledAt','ReportId':0x3},{'field':_0x577ef0('0x131'),'alias':_0x577ef0('0x47'),'ReportId':0x3},{'field':_0x577ef0('0x6e'),'alias':'AgentCompleteAt','ReportId':0x3},{'field':_0x577ef0('0x7c'),'alias':_0x577ef0('0x8b'),'ReportId':0x3},{'field':_0x577ef0('0xe5'),'alias':'TalkTime','ReportId':0x3},{'field':_0x577ef0('0xa3'),'alias':_0x577ef0('0x9b'),'ReportId':0x3},{'field':_0x577ef0('0x79'),'alias':_0x577ef0('0xf'),'ReportId':0x3},{'field':_0x577ef0('0x110'),'alias':_0x577ef0('0x111'),'ReportId':0x3},{'field':_0x577ef0('0x66'),'alias':_0x577ef0('0xc2'),'ReportId':0x3},{'field':_0x577ef0('0x54'),'alias':_0x577ef0('0x7d'),'ReportId':0x3},{'field':_0x577ef0('0x48'),'alias':_0x577ef0('0x123'),'ReportId':0x3},{'field':_0x577ef0('0xf3'),'alias':_0x577ef0('0x5c'),'groupBy':0x1,'ReportId':0x4},{'field':_0x577ef0('0x110'),'alias':_0x577ef0('0xaf'),'function':_0x577ef0('0x130'),'ReportId':0x4},{'field':_0x577ef0('0xe5'),'alias':_0x577ef0('0xeb'),'function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'ReportId':0x4},{'field':_0x577ef0('0x79'),'alias':'TotACWTime','function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'ReportId':0x4},{'field':_0x577ef0('0x116'),'alias':_0x577ef0('0x8'),'function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x4},{'field':'ROUND(AVG(talktime))','alias':_0x577ef0('0xc0'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x4},{'field':_0x577ef0('0x2'),'alias':_0x577ef0('0x89'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x4},{'field':_0x577ef0('0x118'),'alias':'AvgHandleTime','format':'SEC_TO_TIME','custom':0x1,'ReportId':0x4},{'field':'queue','alias':_0x577ef0('0xcd'),'groupBy':0x1,'ReportId':0x5},{'field':'agentcomplete','alias':_0x577ef0('0xaf'),'function':'SUM','ReportId':0x5},{'field':_0x577ef0('0xe5'),'alias':'Tot\x20TalkTime','function':'SUM','format':'SEC_TO_TIME','ReportId':0x5},{'field':'holdtime','alias':'Tot\x20HoldTime','function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'ReportId':0x5},{'field':_0x577ef0('0x79'),'alias':_0x577ef0('0xa7'),'function':_0x577ef0('0x130'),'format':'SEC_TO_TIME','ReportId':0x5},{'field':'talktime\x20+\x20acwtime','alias':_0x577ef0('0x94'),'function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x5},{'field':_0x577ef0('0x77'),'alias':_0x577ef0('0x3c'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x5},{'field':'ROUND(AVG(holdtime))','alias':_0x577ef0('0x96'),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0x5},{'field':_0x577ef0('0x2'),'alias':'Avg\x20ACWTime','format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x5},{'field':_0x577ef0('0x118'),'alias':'Avg\x20Handle\x20Time','format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x5},{'field':_0x577ef0('0x71'),'alias':_0x577ef0('0xcd'),'groupBy':0x1,'ReportId':0x6},{'field':_0x577ef0('0x110'),'alias':'Tot\x20Answered','function':_0x577ef0('0x130'),'ReportId':0x6},{'field':_0x577ef0('0x86'),'alias':_0x577ef0('0xa4'),'custom':0x1,'ReportId':0x6},{'field':'ROUND(COUNT(IF(holdtime<10,1,NULL))\x20/\x20SUM(agentcomplete)\x20*100,1)','alias':_0x577ef0('0x91'),'custom':0x1,'ReportId':0x6},{'field':_0x577ef0('0x58'),'alias':'Answered\x2010-20s','custom':0x1,'ReportId':0x6},{'field':_0x577ef0('0x42'),'alias':_0x577ef0('0x4e'),'custom':0x1,'ReportId':0x6},{'field':_0x577ef0('0xb3'),'alias':'Answered\x2020-30s','custom':0x1,'ReportId':0x6},{'field':'ROUND(COUNT(IF(holdtime\x20>=20\x20AND\x20holdtime\x20<30,1,NULL))\x20/\x20SUM(agentcomplete)\x20*100,1)','alias':_0x577ef0('0x2f'),'custom':0x1,'ReportId':0x6},{'field':_0x577ef0('0x52'),'alias':_0x577ef0('0x11b'),'custom':0x1,'ReportId':0x6},{'field':_0x577ef0('0xef'),'alias':_0x577ef0('0x7a'),'custom':0x1,'ReportId':0x6},{'field':_0x577ef0('0x66'),'alias':_0x577ef0('0x76'),'groupBy':0x1,'ReportId':0x7},{'field':'uniqueid','alias':_0x577ef0('0x22'),'function':_0x577ef0('0xa'),'ReportId':0x7},{'field':_0x577ef0('0x131'),'alias':'Hour','format':_0x577ef0('0x18'),'groupBy':0x1,'ReportId':0x8},{'field':_0x577ef0('0x110'),'alias':_0x577ef0('0x125'),'function':_0x577ef0('0x130'),'ReportId':0x8},{'field':_0x577ef0('0x86'),'alias':_0x577ef0('0xa4'),'custom':0x1,'ReportId':0x8},{'field':_0x577ef0('0x58'),'alias':'Answered\x2010-20s','custom':0x1,'ReportId':0x8},{'field':_0x577ef0('0xb3'),'alias':_0x577ef0('0x1f'),'custom':0x1,'ReportId':0x8},{'field':_0x577ef0('0x52'),'alias':_0x577ef0('0x11b'),'custom':0x1,'ReportId':0x8},{'field':'uniqueid','alias':_0x577ef0('0x92'),'ReportId':0x9},{'field':_0x577ef0('0x59'),'alias':_0x577ef0('0x7f'),'ReportId':0x9},{'field':_0x577ef0('0x71'),'alias':_0x577ef0('0xcd'),'ReportId':0x9},{'field':_0x577ef0('0x17'),'alias':_0x577ef0('0xec'),'ReportId':0x9},{'field':_0x577ef0('0x135'),'alias':'LeaveAt','ReportId':0x9},{'field':'queuecallerabandon','alias':_0x577ef0('0x101'),'ReportId':0x9},{'field':_0x577ef0('0xe0'),'alias':_0x577ef0('0x124'),'ReportId':0x9},{'field':_0x577ef0('0xe2'),'alias':'Unmanaged','ReportId':0x9},{'field':_0x577ef0('0xc7'),'alias':'UnmanagedAt','ReportId':0x9},{'field':'queuecallerexitreason','alias':_0x577ef0('0xbe'),'ReportId':0x9},{'field':_0x577ef0('0x11d'),'alias':'QueuePosition','ReportId':0x9},{'field':'exten','alias':_0x577ef0('0x123'),'ReportId':0x9},{'field':_0x577ef0('0xad'),'alias':_0x577ef0('0x117'),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0x9},{'field':_0x577ef0('0x102'),'alias':'Unmanaged\x20HoldTime','format':'SEC_TO_TIME','custom':0x1,'ReportId':0x9},{'field':_0x577ef0('0x71'),'alias':_0x577ef0('0xcd'),'groupBy':0x1,'ReportId':0xa},{'field':_0x577ef0('0x115'),'alias':_0x577ef0('0x25'),'function':_0x577ef0('0x130'),'ReportId':0xa},{'field':_0x577ef0('0xe2'),'alias':_0x577ef0('0x33'),'function':'SUM','ReportId':0xa},{'field':_0x577ef0('0xad'),'alias':'Tot\x20AbandonTime','function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0xa},{'field':_0x577ef0('0x6d'),'alias':_0x577ef0('0x7e'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0xa},{'field':_0x577ef0('0x102'),'alias':_0x577ef0('0xca'),'function':'SUM','format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0xa},{'field':_0x577ef0('0x56'),'alias':'Avg\x20Unmanaged\x20TIme','format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0xa},{'field':_0x577ef0('0xe'),'alias':_0x577ef0('0x76'),'groupBy':0x1,'ReportId':0xb},{'field':_0x577ef0('0xe2'),'alias':_0x577ef0('0x22'),'function':_0x577ef0('0x130'),'ReportId':0xb},{'field':_0x577ef0('0x102'),'alias':_0x577ef0('0xca'),'function':_0x577ef0('0x130'),'custom':0x1,'ReportId':0xb},{'field':_0x577ef0('0x71'),'alias':_0x577ef0('0xcd'),'groupBy':0x1,'ReportId':0xc},{'field':'queuecallerabandon','alias':'Tot\x20Abandoned','function':'SUM','ReportId':0xc},{'field':_0x577ef0('0xfb'),'alias':_0x577ef0('0x6a'),'custom':0x1,'ReportId':0xc},{'field':_0x577ef0('0x23'),'alias':_0x577ef0('0xa5'),'custom':0x1,'ReportId':0xc},{'field':_0x577ef0('0xe6'),'alias':_0x577ef0('0x2e'),'custom':0x1,'ReportId':0xc},{'field':_0x577ef0('0xd1'),'alias':'Abandoned\x20Rate\x2010-60s','custom':0x1,'ReportId':0xc},{'field':'COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20>=60\x20AND\x20UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20<120,1,NULL))','alias':_0x577ef0('0x121'),'custom':0x1,'ReportId':0xc},{'field':_0x577ef0('0x55'),'alias':'Abandoned\x20Rate\x2060-120s','custom':0x1,'ReportId':0xc},{'field':_0x577ef0('0xae'),'alias':_0x577ef0('0x72'),'custom':0x1,'ReportId':0xc},{'field':_0x577ef0('0xf0'),'alias':_0x577ef0('0xd7'),'custom':0x1,'ReportId':0xc},{'field':_0x577ef0('0xff'),'alias':_0x577ef0('0x134'),'format':_0x577ef0('0x109'),'groupBy':0x1,'custom':0x1,'ReportId':0xd},{'field':'uniqueid','alias':_0x577ef0('0xd8'),'function':'COUNT\x20DISTINCT','ReportId':0xd},{'field':_0x577ef0('0x24'),'alias':'Completed','function':_0x577ef0('0x130'),'ReportId':0xd},{'field':'queuecallerabandon','alias':_0x577ef0('0x25'),'function':'SUM','custom':0x1,'ReportId':0xd},{'field':'queuecallerexit','alias':_0x577ef0('0x33'),'function':'SUM','custom':0x1,'ReportId':0xd},{'field':_0x577ef0('0xb1'),'alias':_0x577ef0('0x34'),'function':_0x577ef0('0x130'),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0xd},{'field':_0x577ef0('0xbb'),'alias':_0x577ef0('0xc0'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0xd},{'field':'ROUND(AVG(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)))','alias':_0x577ef0('0x7e'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0xd},{'field':_0x577ef0('0xff'),'alias':_0x577ef0('0xbf'),'format':_0x577ef0('0x18'),'groupBy':0x1,'custom':0x1,'ReportId':0xe},{'field':_0x577ef0('0x114'),'alias':_0x577ef0('0xd8'),'function':_0x577ef0('0x138'),'ReportId':0xe},{'field':'queuecallercomplete','alias':_0x577ef0('0xa8'),'function':_0x577ef0('0x130'),'ReportId':0xe},{'field':_0x577ef0('0x1a'),'alias':_0x577ef0('0xa0'),'custom':0x1,'ReportId':0xe},{'field':_0x577ef0('0x115'),'alias':_0x577ef0('0x25'),'function':_0x577ef0('0x130'),'ReportId':0xe},{'field':_0x577ef0('0xe2'),'alias':_0x577ef0('0x33'),'function':'SUM','ReportId':0xe},{'field':_0x577ef0('0xb1'),'alias':'Tot\x20TalkTime','function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0xe},{'field':_0x577ef0('0xbb'),'alias':'AvgTalkTime','format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0xe},{'field':_0x577ef0('0x6d'),'alias':'AvgAbandonTime','format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0xe},{'field':'DAY(queuecallerjoinat)','alias':_0x577ef0('0x30'),'groupBy':0x1,'custom':0x1,'ReportId':0xf},{'field':_0x577ef0('0x114'),'alias':_0x577ef0('0xd8'),'function':_0x577ef0('0x138'),'ReportId':0xf},{'field':'queuecallercomplete','alias':_0x577ef0('0xa8'),'function':_0x577ef0('0x130'),'ReportId':0xf},{'field':'ROUND(SUM(queuecallercomplete)/COUNT(DISTINCT\x20uniqueid)*100,1)','alias':_0x577ef0('0xa0'),'custom':0x1,'ReportId':0xf},{'field':_0x577ef0('0x115'),'alias':'Abandoned','function':'SUM','ReportId':0xf},{'field':_0x577ef0('0xe2'),'alias':_0x577ef0('0x33'),'function':_0x577ef0('0x130'),'ReportId':0xf},{'field':'UNIX_TIMESTAMP(queuecallercompleteAt)-UNIX_TIMESTAMP(queuecallerleaveAt)','alias':'Tot\x20TalkTime','function':'SUM','format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0xf},{'field':_0x577ef0('0xbb'),'alias':_0x577ef0('0xc0'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0xf},{'field':'ROUND(AVG(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)))','alias':'AvgAbandonTime','format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0xf},{'field':_0x577ef0('0x5e'),'alias':_0x577ef0('0x137'),'groupBy':0x1,'custom':0x1,'ReportId':0x10},{'field':_0x577ef0('0x114'),'alias':_0x577ef0('0xd8'),'function':'COUNT\x20DISTINCT','ReportId':0x10},{'field':_0x577ef0('0x24'),'alias':_0x577ef0('0xa8'),'function':_0x577ef0('0x130'),'ReportId':0x10},{'field':_0x577ef0('0x1a'),'alias':_0x577ef0('0xa0'),'custom':0x1,'ReportId':0x10},{'field':_0x577ef0('0x115'),'alias':_0x577ef0('0x25'),'function':_0x577ef0('0x130'),'orderBy':_0x577ef0('0x103'),'ReportId':0x10},{'field':_0x577ef0('0xe2'),'alias':'Unmanaged','function':_0x577ef0('0x130'),'ReportId':0x10},{'field':'UNIX_TIMESTAMP(queuecallercompleteAt)-UNIX_TIMESTAMP(queuecallerleaveAt)','alias':_0x577ef0('0x34'),'function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x10},{'field':'ROUND(AVG(UNIX_TIMESTAMP(queuecallercompleteAt)-UNIX_TIMESTAMP(queuecallerleaveAt)))','alias':_0x577ef0('0xc0'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x10},{'field':_0x577ef0('0x6d'),'alias':_0x577ef0('0x7e'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x10},{'field':_0x577ef0('0x71'),'alias':_0x577ef0('0xcd'),'groupBy':0x1,'ReportId':0x11},{'field':_0x577ef0('0x114'),'alias':_0x577ef0('0xd8'),'function':_0x577ef0('0x138'),'ReportId':0x11},{'field':_0x577ef0('0x24'),'alias':_0x577ef0('0xa8'),'function':'SUM','ReportId':0x11},{'field':'ROUND(SUM(queuecallercomplete)/COUNT(DISTINCT\x20uniqueid)*100,1)','alias':'Answer\x20Rate','custom':0x1,'ReportId':0x11},{'field':'queuecallerabandon','alias':_0x577ef0('0x25'),'function':_0x577ef0('0x130'),'ReportId':0x11},{'field':_0x577ef0('0xe2'),'alias':_0x577ef0('0x33'),'function':_0x577ef0('0x130'),'ReportId':0x11},{'field':_0x577ef0('0xb1'),'alias':_0x577ef0('0x34'),'function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x11},{'field':_0x577ef0('0xbb'),'alias':_0x577ef0('0xc0'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x11},{'field':_0x577ef0('0x6d'),'alias':_0x577ef0('0x7e'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x11},{'field':'uniqueid','alias':'UniqueID','ReportId':0x12},{'field':_0x577ef0('0xbd'),'alias':_0x577ef0('0x51'),'ReportId':0x12},{'field':_0x577ef0('0x127'),'alias':_0x577ef0('0x80'),'ReportId':0x12},{'field':_0x577ef0('0x129'),'alias':_0x577ef0('0x9c'),'ReportId':0x12},{'field':_0x577ef0('0x84'),'alias':_0x577ef0('0xd9'),'ReportId':0x12},{'field':'callerid','alias':_0x577ef0('0xdd'),'ReportId':0x12},{'field':_0x577ef0('0xcf'),'alias':_0x577ef0('0xd3'),'ReportId':0x12},{'field':_0x577ef0('0x12e'),'alias':_0x577ef0('0x16'),'ReportId':0x12},{'field':_0x577ef0('0xf1'),'alias':_0x577ef0('0x1b'),'ReportId':0x12},{'field':_0x577ef0('0xfd'),'alias':_0x577ef0('0x132'),'ReportId':0x12},{'field':_0x577ef0('0x61'),'alias':_0x577ef0('0x8b'),'ReportId':0x12},{'field':_0x577ef0('0x9e'),'alias':_0x577ef0('0x136'),'ReportId':0x12},{'field':_0x577ef0('0xc9'),'alias':_0x577ef0('0x9a'),'ReportId':0x12},{'field':_0x577ef0('0x12d'),'alias':_0x577ef0('0x3d'),'ReportId':0x12},{'field':_0x577ef0('0x114'),'alias':'UniqueID','ReportId':0x13},{'field':_0x577ef0('0xf4'),'alias':_0x577ef0('0x6c'),'ReportId':0x13},{'field':'source','alias':'Source','ReportId':0x13},{'field':_0x577ef0('0x84'),'alias':_0x577ef0('0xd9'),'ReportId':0x13},{'field':'callerid','alias':_0x577ef0('0x10f'),'ReportId':0x13},{'field':'starttime','alias':_0x577ef0('0x132'),'ReportId':0x13},{'field':'answertime','alias':_0x577ef0('0x8b'),'ReportId':0x13},{'field':_0x577ef0('0x9e'),'alias':_0x577ef0('0x136'),'ReportId':0x13},{'field':'duration','alias':'Duration','format':_0x577ef0('0x63'),'ReportId':0x13},{'field':_0x577ef0('0x12c'),'alias':'Billsec','format':_0x577ef0('0x63'),'ReportId':0x13},{'field':_0x577ef0('0x12d'),'alias':_0x577ef0('0x3d'),'ReportId':0x13},{'field':'tag','alias':_0x577ef0('0x80'),'ReportId':0x13},{'field':_0x577ef0('0xbd'),'alias':_0x577ef0('0x51'),'groupBy':0x1,'ReportId':0x14},{'field':_0x577ef0('0x114'),'alias':_0x577ef0('0x22'),'function':_0x577ef0('0xa'),'ReportId':0x14},{'field':_0x577ef0('0xc9'),'alias':_0x577ef0('0x7'),'function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'ReportId':0x14},{'field':_0x577ef0('0x32'),'alias':_0x577ef0('0x85'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x14},{'field':_0x577ef0('0x12d'),'alias':_0x577ef0('0x3d'),'groupBy':0x1,'ReportId':0x15},{'field':_0x577ef0('0x114'),'alias':_0x577ef0('0x22'),'function':_0x577ef0('0xa'),'ReportId':0x15},{'field':_0x577ef0('0xc9'),'alias':_0x577ef0('0x7'),'function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'ReportId':0x15},{'field':'ROUND(AVG(duration))','alias':_0x577ef0('0x85'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x15},{'field':_0x577ef0('0x1d'),'alias':_0x577ef0('0x5c'),'groupBy':0x1,'custom':0x1,'ReportId':0x16},{'field':_0x577ef0('0x114'),'alias':_0x577ef0('0x22'),'function':_0x577ef0('0xa'),'ReportId':0x16},{'field':_0x577ef0('0xc9'),'alias':'Tot\x20Duration','function':_0x577ef0('0x130'),'format':'SEC_TO_TIME','ReportId':0x16},{'field':_0x577ef0('0x32'),'alias':'Avg\x20Duration','format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x16},{'field':'starttime','alias':_0x577ef0('0x134'),'format':_0x577ef0('0x109'),'groupBy':0x1,'ReportId':0x17},{'field':_0x577ef0('0x114'),'alias':_0x577ef0('0x22'),'function':_0x577ef0('0xa'),'ReportId':0x17},{'field':_0x577ef0('0xc9'),'alias':_0x577ef0('0x7'),'function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'ReportId':0x17},{'field':_0x577ef0('0x32'),'alias':_0x577ef0('0x85'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x17},{'field':_0x577ef0('0xf3'),'alias':_0x577ef0('0x5c'),'groupBy':0x1,'orderBy':'ASC','ReportId':0x18},{'field':_0x577ef0('0x98'),'alias':_0x577ef0('0x9a'),'function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x18},{'field':_0x577ef0('0xf3'),'alias':'Agent','groupBy':0x1,'ReportId':0x19},{'field':_0x577ef0('0x119'),'alias':_0x577ef0('0x67'),'function':'SUM','format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x19},{'field':'CASE\x20WHEN\x20type=\x27TALKING\x27\x20THEN\x20UNIX_TIMESTAMP(exitAt)-UNIX_TIMESTAMP(enterAt)\x20END','alias':'Talk\x20Time','function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x19},{'field':_0x577ef0('0x4'),'alias':_0x577ef0('0x10'),'function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x19},{'field':_0x577ef0('0xf3'),'alias':_0x577ef0('0x5c'),'ReportId':0x1a},{'field':'enterAt','alias':_0x577ef0('0x39'),'ReportId':0x1a},{'field':_0x577ef0('0x29'),'alias':_0x577ef0('0xc8'),'ReportId':0x1a},{'field':_0x577ef0('0xdf'),'alias':'Pause','ReportId':0x1a},{'field':_0x577ef0('0xc9'),'alias':_0x577ef0('0x9a'),'format':_0x577ef0('0x63'),'ReportId':0x1a},{'field':_0x577ef0('0xf3'),'alias':_0x577ef0('0x5c'),'ReportId':0x1b},{'field':_0x577ef0('0xe8'),'alias':_0x577ef0('0xc4'),'ReportId':0x1b},{'field':_0x577ef0('0xbd'),'alias':_0x577ef0('0x5'),'ReportId':0x1b},{'field':_0x577ef0('0xdf'),'alias':_0x577ef0('0x51'),'ReportId':0x1b},{'field':_0x577ef0('0xd4'),'alias':_0x577ef0('0x39'),'ReportId':0x1b},{'field':'exitAt','alias':_0x577ef0('0xc8'),'ReportId':0x1b},{'field':_0x577ef0('0x98'),'alias':_0x577ef0('0x9a'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x1b},{'field':_0x577ef0('0xf3'),'alias':_0x577ef0('0x5c'),'groupBy':0x1,'orderBy':_0x577ef0('0x103'),'ReportId':0x1c},{'field':_0x577ef0('0xdf'),'alias':_0x577ef0('0xac'),'groupBy':0x1,'orderBy':_0x577ef0('0x103'),'ReportId':0x1c},{'field':_0x577ef0('0x98'),'alias':_0x577ef0('0x9a'),'function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x1c},{'field':_0x577ef0('0xba'),'alias':_0x577ef0('0xb6'),'ReportId':0x1d},{'field':'uniqueid','alias':_0x577ef0('0x92'),'ReportId':0x1d},{'field':_0x577ef0('0x8e'),'alias':'CallerId','ReportId':0x1d},{'field':_0x577ef0('0xa9'),'alias':'DID','ReportId':0x1d},{'field':'joinAt','alias':'Start\x20Time','orderBy':_0x577ef0('0x103'),'ReportId':0x1d},{'field':_0x577ef0('0x26'),'alias':_0x577ef0('0x1e'),'ReportId':0x1d},{'field':'UNIX_TIMESTAMP(leaveAt)-UNIX_TIMESTAMP(joinAt)','alias':_0x577ef0('0x9a'),'format':_0x577ef0('0x63'),'custom':0x1,'ReportId':0x1d},{'field':_0x577ef0('0x114'),'alias':_0x577ef0('0xaa'),'ReportId':0x1e},{'field':_0x577ef0('0xba'),'alias':_0x577ef0('0xb6'),'ReportId':0x1e},{'field':_0x577ef0('0x8e'),'alias':'Caller\x20Id','ReportId':0x1e},{'field':_0x577ef0('0x105'),'alias':_0x577ef0('0xcb'),'ReportId':0x1e},{'field':_0x577ef0('0x44'),'alias':_0x577ef0('0x2d'),'ReportId':0x1e},{'field':_0x577ef0('0x1'),'alias':'Agent','groupBy':0x1,'ReportId':0x1f},{'field':'uniqueid','alias':_0x577ef0('0x74'),'function':_0x577ef0('0xa'),'ReportId':0x1f},{'field':_0x577ef0('0xe7'),'alias':'Total\x20Rating','function':'SUM','ReportId':0x1f},{'field':_0x577ef0('0xe7'),'alias':_0x577ef0('0x11'),'function':'AVG','ReportId':0x1f},{'field':_0x577ef0('0x71'),'alias':_0x577ef0('0xcd'),'groupBy':0x1,'ReportId':0x20},{'field':_0x577ef0('0x114'),'alias':_0x577ef0('0xee'),'function':'COUNT','ReportId':0x20},{'field':_0x577ef0('0xe7'),'alias':_0x577ef0('0xb9'),'function':_0x577ef0('0x130'),'ReportId':0x20},{'field':'rating','alias':'Avg\x20Rating','function':_0x577ef0('0x120'),'ReportId':0x20},{'field':_0x577ef0('0x83'),'alias':_0x577ef0('0x6'),'ReportId':0x21},{'field':'calleridnum','alias':_0x577ef0('0x7f'),'ReportId':0x21},{'field':_0x577ef0('0xfd'),'alias':'LastCallAt','orderBy':'DESC','ReportId':0x21},{'field':_0x577ef0('0x9'),'alias':'State','ReportId':0x21},{'field':_0x577ef0('0x5b'),'alias':_0x577ef0('0x11c'),'ReportId':0x21},{'field':_0x577ef0('0x64'),'alias':_0x577ef0('0xdc'),'ReportId':0x21},{'field':_0x577ef0('0xe3'),'alias':_0x577ef0('0xd'),'ReportId':0x21},{'field':_0x577ef0('0xf3'),'alias':_0x577ef0('0x5c'),'ReportId':0x21},{'field':_0x577ef0('0xe5'),'alias':'Talk\x20Time','ReportId':0x21},{'field':_0x577ef0('0x12d'),'alias':_0x577ef0('0x3d'),'ReportId':0x21},{'field':_0x577ef0('0x114'),'alias':_0x577ef0('0x92'),'ReportId':0x21},{'field':_0x577ef0('0x9'),'alias':_0x577ef0('0xfe'),'groupBy':!![],'orderBy':_0x577ef0('0x103'),'ReportId':0x22},{'field':'id','alias':_0x577ef0('0x22'),'function':_0x577ef0('0xa'),'ReportId':0x22},{'field':_0x577ef0('0xb8'),'alias':_0x577ef0('0x31'),'custom':!![],'ReportId':0x22},{'field':_0x577ef0('0x83'),'alias':_0x577ef0('0x6'),'orderBy':_0x577ef0('0x103'),'groupBy':!![],'ReportId':0x23},{'field':'statedesc','alias':_0x577ef0('0xfe'),'groupBy':!![],'ReportId':0x23},{'field':'id','alias':_0x577ef0('0x73'),'function':_0x577ef0('0xa'),'ReportId':0x23},{'field':_0x577ef0('0x108'),'groupBy':!![],'orderBy':'ASC','ReportId':0x24},{'field':'id','alias':'Contacts','function':'COUNT','ReportId':0x24},{'field':_0x577ef0('0x69'),'alias':_0x577ef0('0x5d'),'custom':!![],'ReportId':0x24},{'field':_0x577ef0('0x46'),'alias':_0x577ef0('0x2a'),'custom':!![],'ReportId':0x24},{'field':'membername','alias':_0x577ef0('0x5c'),'groupBy':!![],'orderBy':_0x577ef0('0x103'),'ReportId':0x25},{'field':'id','alias':_0x577ef0('0x22'),'function':_0x577ef0('0xa'),'ReportId':0x25},{'field':_0x577ef0('0x20'),'alias':_0x577ef0('0x13b'),'custom':!![],'ReportId':0x25},{'field':'disposition','alias':'Disposition','groupBy':!![],'ReportId':0x26},{'field':'id','alias':_0x577ef0('0xb7'),'function':_0x577ef0('0xa'),'ReportId':0x26},{'field':_0x577ef0('0xf7'),'alias':'Total\x20(%)','custom':!![],'ReportId':0x26},{'field':_0x577ef0('0xf3'),'alias':_0x577ef0('0x5c'),'groupBy':!![],'ReportId':0x27},{'field':_0x577ef0('0x12d'),'alias':_0x577ef0('0x3d'),'groupBy':!![],'ReportId':0x27},{'field':'id','alias':_0x577ef0('0xb7'),'function':_0x577ef0('0xa'),'ReportId':0x27},{'field':_0x577ef0('0xf7'),'alias':_0x577ef0('0xb2'),'custom':!![],'ReportId':0x27},{'field':_0x577ef0('0x83'),'alias':'Campaign\x20Name','ReportId':0x28},{'field':_0x577ef0('0x59'),'alias':_0x577ef0('0x7f'),'ReportId':0x28},{'field':_0x577ef0('0xfd'),'alias':_0x577ef0('0x1c'),'orderBy':_0x577ef0('0x19'),'ReportId':0x28},{'field':_0x577ef0('0x9'),'alias':_0x577ef0('0xfe'),'ReportId':0x28},{'field':_0x577ef0('0x5b'),'alias':_0x577ef0('0x11c'),'ReportId':0x28},{'field':_0x577ef0('0x64'),'alias':_0x577ef0('0xdc'),'ReportId':0x28},{'field':'blacklist','alias':_0x577ef0('0xd'),'ReportId':0x28},{'field':_0x577ef0('0xe5'),'alias':_0x577ef0('0xc5'),'ReportId':0x28},{'field':_0x577ef0('0x114'),'alias':'UniqueId','ReportId':0x28},{'field':'statedesc','alias':_0x577ef0('0xfe'),'groupBy':!![],'orderBy':_0x577ef0('0x103'),'ReportId':0x29},{'field':'id','alias':_0x577ef0('0x22'),'function':_0x577ef0('0xa'),'ReportId':0x29},{'field':_0x577ef0('0x75'),'alias':'Calls\x20(%)','custom':!![],'ReportId':0x29},{'field':_0x577ef0('0x83'),'alias':'Campaign\x20Name','orderBy':'ASC','groupBy':!![],'ReportId':0x2a},{'field':_0x577ef0('0x9'),'alias':'State','groupBy':!![],'ReportId':0x2a},{'field':'id','alias':'Total\x20Calls','function':'COUNT','ReportId':0x2a},{'field':'ListId','groupBy':!![],'orderBy':'ASC','ReportId':0x2b},{'field':'id','alias':'Contacts','function':_0x577ef0('0xa'),'ReportId':0x2b},{'field':_0x577ef0('0x69'),'alias':_0x577ef0('0x5d'),'custom':!![],'ReportId':0x2b},{'field':_0x577ef0('0x46'),'alias':'Penetration\x20Rate','custom':!![],'ReportId':0x2b},{'field':_0x577ef0('0xb0'),'alias':'Web\x20Site','groupBy':!![],'ReportId':0x2c},{'field':'chat_interactions.id','alias':_0x577ef0('0x4b'),'function':_0x577ef0('0xa'),'ReportId':0x2c},{'field':_0x577ef0('0x9f'),'alias':_0x577ef0('0x12a'),'custom':!![],'ReportId':0x2c},{'field':_0x577ef0('0x10a'),'alias':_0x577ef0('0x133'),'custom':!![],'ReportId':0x2c},{'field':'COUNT(IF(closed=1\x20&&\x20disposition\x20=\x27unmanaged\x27,1,NULL))','alias':_0x577ef0('0x33'),'custom':!![],'ReportId':0x2c},{'field':_0x577ef0('0x21'),'alias':_0x577ef0('0x25'),'custom':!![],'ReportId':0x2c},{'field':'chat_websites.name','alias':_0x577ef0('0x93'),'groupBy':!![],'ReportId':0x2d},{'field':_0x577ef0('0x57'),'alias':_0x577ef0('0xb5'),'function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x2d},{'field':_0x577ef0('0x3'),'alias':_0x577ef0('0xd6'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x2d},{'field':'users.fullname','alias':_0x577ef0('0x5c'),'groupBy':!![],'ReportId':0x2e},{'field':_0x577ef0('0x100'),'alias':_0x577ef0('0x133'),'function':'SUM','ReportId':0x2e},{'field':_0x577ef0('0x57'),'alias':_0x577ef0('0xb5'),'function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x2e},{'field':'ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(chat_interactions.createdAt)))','alias':_0x577ef0('0xd6'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x2e},{'field':_0x577ef0('0x99'),'alias':_0x577ef0('0x134'),'format':_0x577ef0('0x109'),'groupBy':!![],'custom':!![],'ReportId':0x2f},{'field':_0x577ef0('0x37'),'alias':_0x577ef0('0x4b'),'function':_0x577ef0('0xa'),'ReportId':0x2f},{'field':_0x577ef0('0x10a'),'alias':_0x577ef0('0xaf'),'custom':!![],'ReportId':0x2f},{'field':_0x577ef0('0x8d'),'alias':_0x577ef0('0x41'),'custom':!![],'ReportId':0x2f},{'field':_0x577ef0('0xda'),'alias':_0x577ef0('0x33'),'custom':!![],'ReportId':0x2f},{'field':_0x577ef0('0x60'),'alias':_0x577ef0('0x8a'),'custom':!![],'ReportId':0x2f},{'field':_0x577ef0('0x21'),'alias':'Abandoned','custom':!![],'ReportId':0x2f},{'field':_0x577ef0('0x97'),'alias':_0x577ef0('0x68'),'custom':!![],'ReportId':0x2f},{'field':'UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)','alias':_0x577ef0('0xb5'),'function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x2f},{'field':'ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)))','alias':_0x577ef0('0xd6'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x2f},{'field':_0x577ef0('0x5f'),'alias':_0x577ef0('0xcd'),'groupBy':!![],'ReportId':0x30},{'field':_0x577ef0('0x107'),'alias':_0x577ef0('0x4b'),'function':_0x577ef0('0xa'),'ReportId':0x30},{'field':_0x577ef0('0xfa'),'alias':_0x577ef0('0x104'),'custom':!![],'ReportId':0x30},{'field':_0x577ef0('0x7b'),'alias':_0x577ef0('0x3e'),'custom':!![],'ReportId':0x30},{'field':'UNIX_TIMESTAMP(leaveAt)-UNIX_TIMESTAMP(joinAt)','alias':_0x577ef0('0xdb'),'function':'SUM','format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x30},{'field':'ROUND(AVG(UNIX_TIMESTAMP(leaveAt)-UNIX_TIMESTAMP(joinAt)))','alias':_0x577ef0('0x4f'),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x30},{'field':'mail_accounts.name','alias':_0x577ef0('0x88'),'groupBy':!![],'ReportId':0x31},{'field':_0x577ef0('0x81'),'alias':_0x577ef0('0x4b'),'function':'COUNT','ReportId':0x31},{'field':_0x577ef0('0x9f'),'alias':'Open','custom':!![],'ReportId':0x31},{'field':_0x577ef0('0xd0'),'alias':_0x577ef0('0x133'),'custom':!![],'ReportId':0x31},{'field':_0x577ef0('0x87'),'alias':_0x577ef0('0x88'),'groupBy':!![],'ReportId':0x32},{'field':_0x577ef0('0x8f'),'alias':'Interaction\x20Time','function':'SUM','format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x32},{'field':_0x577ef0('0x10c'),'alias':_0x577ef0('0xd6'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x32},{'field':_0x577ef0('0x11e'),'alias':'Agent','groupBy':!![],'ReportId':0x33},{'field':_0x577ef0('0xd5'),'alias':'Closed','function':_0x577ef0('0x130'),'ReportId':0x33},{'field':_0x577ef0('0x8f'),'alias':_0x577ef0('0xb5'),'function':'SUM','format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x33},{'field':_0x577ef0('0x10c'),'alias':_0x577ef0('0xd6'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x33},{'field':_0x577ef0('0xa6'),'alias':'Date','format':_0x577ef0('0x109'),'groupBy':!![],'custom':!![],'ReportId':0x34},{'field':_0x577ef0('0x81'),'alias':_0x577ef0('0x4b'),'function':_0x577ef0('0xa'),'ReportId':0x34},{'field':_0x577ef0('0xd0'),'alias':'Completed','custom':!![],'ReportId':0x34},{'field':_0x577ef0('0x53'),'alias':_0x577ef0('0x41'),'custom':!![],'ReportId':0x34},{'field':'UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)','alias':_0x577ef0('0xb5'),'function':'SUM','format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x34},{'field':'ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)))','alias':'AVG\x20Interaction\x20Time','format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x34},{'field':_0x577ef0('0x70'),'alias':'Queue','groupBy':!![],'ReportId':0x35},{'field':_0x577ef0('0xf6'),'alias':_0x577ef0('0x4b'),'function':_0x577ef0('0xa'),'ReportId':0x35},{'field':'COUNT(IF(reason=\x27accepted\x27,1,NULL))','alias':_0x577ef0('0x104'),'custom':!![],'ReportId':0x35},{'field':_0x577ef0('0x7b'),'alias':'Timeout','custom':!![],'ReportId':0x35},{'field':_0x577ef0('0x12f'),'alias':_0x577ef0('0xdb'),'function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x35},{'field':_0x577ef0('0x113'),'alias':_0x577ef0('0x4f'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x35},{'field':'openchannel_accounts.name','alias':_0x577ef0('0x122'),'groupBy':!![],'ReportId':0x36},{'field':_0x577ef0('0xde'),'alias':'Interactions','function':_0x577ef0('0xa'),'ReportId':0x36},{'field':'COUNT(IF(closed=0,1,NULL))','alias':_0x577ef0('0x12a'),'custom':!![],'ReportId':0x36},{'field':_0x577ef0('0xd0'),'alias':'Closed','custom':!![],'ReportId':0x36},{'field':'openchannel_accounts.name','alias':_0x577ef0('0x122'),'groupBy':!![],'ReportId':0x37},{'field':'UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(openchannel_interactions.createdAt)','alias':'Interaction\x20Time','function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x37},{'field':_0x577ef0('0x9d'),'alias':_0x577ef0('0xd6'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x37},{'field':_0x577ef0('0x11e'),'alias':_0x577ef0('0x5c'),'groupBy':!![],'ReportId':0x38},{'field':_0x577ef0('0x28'),'alias':_0x577ef0('0x133'),'function':_0x577ef0('0x130'),'ReportId':0x38},{'field':_0x577ef0('0xcc'),'alias':_0x577ef0('0xb5'),'function':'SUM','format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x38},{'field':_0x577ef0('0x9d'),'alias':_0x577ef0('0xd6'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x38},{'field':_0x577ef0('0x49'),'alias':_0x577ef0('0x134'),'format':_0x577ef0('0x109'),'groupBy':!![],'custom':!![],'ReportId':0x39},{'field':_0x577ef0('0xde'),'alias':'Interactions','function':'COUNT','ReportId':0x39},{'field':'COUNT(IF(closed=1,1,NULL))','alias':_0x577ef0('0xaf'),'custom':!![],'ReportId':0x39},{'field':_0x577ef0('0x53'),'alias':_0x577ef0('0x41'),'custom':!![],'ReportId':0x39},{'field':_0x577ef0('0xc'),'alias':_0x577ef0('0xb5'),'function':_0x577ef0('0x130'),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x39},{'field':_0x577ef0('0x50'),'alias':_0x577ef0('0xd6'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x39},{'field':'openchannel_queues.name','alias':_0x577ef0('0xcd'),'groupBy':!![],'ReportId':0x3a},{'field':_0x577ef0('0x82'),'alias':_0x577ef0('0x4b'),'function':_0x577ef0('0xa'),'ReportId':0x3a},{'field':_0x577ef0('0xfa'),'alias':'Accepted','custom':!![],'ReportId':0x3a},{'field':'COUNT(IF(reason=\x27timeout\x27,1,NULL))','alias':_0x577ef0('0x3e'),'custom':!![],'ReportId':0x3a},{'field':_0x577ef0('0x12f'),'alias':_0x577ef0('0xdb'),'function':'SUM','format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x3a},{'field':_0x577ef0('0x113'),'alias':'AVG\x20Hold\x20Time','format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x3a},{'field':_0x577ef0('0xa2'),'alias':_0x577ef0('0x13a'),'groupBy':!![],'ReportId':0x3b},{'field':_0x577ef0('0x10d'),'alias':'Interactions','function':_0x577ef0('0xa'),'ReportId':0x3b},{'field':'COUNT(IF(closed=0,1,NULL))','alias':_0x577ef0('0x12a'),'custom':!![],'ReportId':0x3b},{'field':_0x577ef0('0xd0'),'alias':'Closed','custom':!![],'ReportId':0x3b},{'field':_0x577ef0('0xa2'),'alias':_0x577ef0('0x13a'),'groupBy':!![],'ReportId':0x3c},{'field':_0x577ef0('0xe1'),'alias':'Interaction\x20Time','function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x3c},{'field':_0x577ef0('0x14'),'alias':_0x577ef0('0xd6'),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x3c},{'field':_0x577ef0('0x11e'),'alias':_0x577ef0('0x5c'),'groupBy':!![],'ReportId':0x3d},{'field':'sms_interactions.closed','alias':_0x577ef0('0x133'),'function':_0x577ef0('0x130'),'ReportId':0x3d},{'field':_0x577ef0('0xe1'),'alias':'Interaction\x20Time','function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x3d},{'field':_0x577ef0('0x14'),'alias':_0x577ef0('0xd6'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x3d},{'field':_0x577ef0('0x0'),'alias':'Date','format':_0x577ef0('0x109'),'groupBy':!![],'custom':!![],'ReportId':0x3e},{'field':_0x577ef0('0x10d'),'alias':_0x577ef0('0x4b'),'function':_0x577ef0('0xa'),'ReportId':0x3e},{'field':_0x577ef0('0xd0'),'alias':_0x577ef0('0xaf'),'custom':!![],'ReportId':0x3e},{'field':'ROUND(COUNT(IF(closed=1,1,NULL))/COUNT(id)\x20*100,1)','alias':_0x577ef0('0x41'),'custom':!![],'ReportId':0x3e},{'field':_0x577ef0('0xc'),'alias':_0x577ef0('0xb5'),'function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x3e},{'field':_0x577ef0('0x50'),'alias':_0x577ef0('0xd6'),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x3e},{'field':_0x577ef0('0x2b'),'alias':_0x577ef0('0xcd'),'groupBy':!![],'ReportId':0x3f},{'field':_0x577ef0('0xfc'),'alias':_0x577ef0('0x4b'),'function':'COUNT','ReportId':0x3f},{'field':_0x577ef0('0xfa'),'alias':'Accepted','custom':!![],'ReportId':0x3f},{'field':'COUNT(IF(reason=\x27timeout\x27,1,NULL))','alias':'Timeout','custom':!![],'ReportId':0x3f},{'field':_0x577ef0('0x12f'),'alias':_0x577ef0('0xdb'),'function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x3f},{'field':_0x577ef0('0x113'),'alias':'AVG\x20Hold\x20Time','format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x3f},{'field':'fax_queues.name','alias':_0x577ef0('0xcd'),'groupBy':!![],'ReportId':0x44},{'field':_0x577ef0('0x4a'),'alias':_0x577ef0('0x4b'),'function':_0x577ef0('0xa'),'ReportId':0x44},{'field':_0x577ef0('0xfa'),'alias':'Accepted','custom':!![],'ReportId':0x44},{'field':'COUNT(IF(reason=\x27timeout\x27,1,NULL))','alias':_0x577ef0('0x3e'),'custom':!![],'ReportId':0x44},{'field':_0x577ef0('0x12f'),'alias':_0x577ef0('0xdb'),'function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x44},{'field':_0x577ef0('0x113'),'alias':'AVG\x20Hold\x20Time','format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x44},{'field':_0x577ef0('0xf2'),'alias':_0x577ef0('0x134'),'format':_0x577ef0('0x109'),'groupBy':!![],'custom':!![],'ReportId':0x43},{'field':_0x577ef0('0xea'),'alias':_0x577ef0('0x4b'),'function':'COUNT','ReportId':0x43},{'field':'COUNT(IF(closed=1,1,NULL))','alias':_0x577ef0('0xaf'),'custom':!![],'ReportId':0x43},{'field':_0x577ef0('0x53'),'alias':'Completed\x20(%)','custom':!![],'ReportId':0x43},{'field':_0x577ef0('0xc'),'alias':'Interaction\x20Time','function':'SUM','format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x43},{'field':_0x577ef0('0x50'),'alias':'AVG\x20Interaction\x20Time','format':'SEC_TO_TIME','custom':!![],'ReportId':0x43},{'field':_0x577ef0('0x11e'),'alias':_0x577ef0('0x5c'),'groupBy':!![],'ReportId':0x42},{'field':_0x577ef0('0x35'),'alias':_0x577ef0('0x133'),'function':'SUM','ReportId':0x42},{'field':_0x577ef0('0x3b'),'alias':'Interaction\x20Time','function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x42},{'field':'ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(fax_interactions.createdAt)))','alias':_0x577ef0('0xd6'),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x42},{'field':_0x577ef0('0xc6'),'alias':_0x577ef0('0x128'),'groupBy':!![],'ReportId':0x41},{'field':'UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(fax_interactions.createdAt)','alias':_0x577ef0('0xb5'),'function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x41},{'field':_0x577ef0('0x112'),'alias':_0x577ef0('0xd6'),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x41},{'field':_0x577ef0('0xc6'),'alias':_0x577ef0('0x128'),'groupBy':!![],'ReportId':0x40},{'field':_0x577ef0('0xea'),'alias':_0x577ef0('0x4b'),'function':_0x577ef0('0xa'),'ReportId':0x40},{'field':_0x577ef0('0x9f'),'alias':_0x577ef0('0x12a'),'custom':!![],'ReportId':0x40},{'field':_0x577ef0('0xd0'),'alias':_0x577ef0('0x133'),'custom':!![],'ReportId':0x40},{'field':_0x577ef0('0x6b'),'alias':_0x577ef0('0xc1'),'groupBy':!![],'custom':![],'ReportId':0x4a},{'field':'users.fullname','alias':_0x577ef0('0xab'),'groupBy':![],'custom':![],'ReportId':0x4a},{'field':_0x577ef0('0xbc'),'alias':_0x577ef0('0x5a'),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x577ef0('0x6f'),'alias':_0x577ef0('0x62'),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x577ef0('0xe9'),'alias':_0x577ef0('0x139'),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x577ef0('0xb'),'alias':_0x577ef0('0x4d'),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x577ef0('0x10b'),'alias':_0x577ef0('0x40'),'function':_0x577ef0('0xa'),'groupBy':![],'custom':![],'ReportId':0x4a},{'field':'CONCAT(ROUND((\x20(SELECT\x20COUNT(IF(voice_recordings.sentiment\x20=\x20\x27POSITIVE\x27,1,NULL)))*100/\x20COUNT\x20(voice_recordings.sentiment)),2),\x27%\x27)','alias':_0x577ef0('0xf9'),'groupBy':![],'custom':!![],'ReportId':0x45},{'field':'CONCAT(ROUND((\x20(SELECT\x20COUNT(IF(voice_recordings.sentiment\x20=\x20\x27NEGATIVE\x27,1,NULL)))*100/\x20COUNT\x20(voice_recordings.sentiment)),2),\x27%\x27)','alias':_0x577ef0('0xd2'),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':'CONCAT(ROUND((\x20(SELECT\x20COUNT(IF(voice_recordings.sentiment\x20=\x20\x27NEUTRAL\x27,1,NULL)))*100/\x20COUNT\x20(voice_recordings.sentiment)),2),\x27%\x27)','alias':'Neutral(%)','groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x577ef0('0xf8'),'alias':_0x577ef0('0x126'),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x577ef0('0x10b'),'alias':'Sentiment\x20TOT','function':_0x577ef0('0xa'),'groupBy':![],'custom':![],'ReportId':0x4b},{'field':_0x577ef0('0xbc'),'alias':'POSITIVE','groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x577ef0('0x6f'),'alias':_0x577ef0('0x62'),'groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x577ef0('0xe9'),'alias':_0x577ef0('0x139'),'groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x577ef0('0xb'),'alias':_0x577ef0('0x4d'),'groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x577ef0('0x65'),'alias':_0x577ef0('0xf9'),'groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x577ef0('0x11f'),'alias':_0x577ef0('0xd2'),'groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x577ef0('0x3f'),'alias':_0x577ef0('0xb4'),'groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x577ef0('0xf8'),'alias':'Mixed(%)','groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x577ef0('0x12b'),'alias':_0x577ef0('0x12'),'groupBy':!![],'ReportId':0x45},{'field':'whatsapp_interactions.id','alias':_0x577ef0('0x4b'),'function':_0x577ef0('0xa'),'ReportId':0x45},{'field':_0x577ef0('0x9f'),'alias':_0x577ef0('0x12a'),'custom':!![],'ReportId':0x45},{'field':_0x577ef0('0xd0'),'alias':_0x577ef0('0x133'),'custom':!![],'ReportId':0x45},{'field':_0x577ef0('0x12b'),'alias':_0x577ef0('0x12'),'groupBy':!![],'ReportId':0x46},{'field':_0x577ef0('0xa1'),'alias':_0x577ef0('0xb5'),'function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x46},{'field':_0x577ef0('0x2c'),'alias':_0x577ef0('0xd6'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x46},{'field':_0x577ef0('0x11e'),'alias':_0x577ef0('0x5c'),'groupBy':!![],'ReportId':0x47},{'field':_0x577ef0('0x11a'),'alias':'Closed','function':_0x577ef0('0x130'),'ReportId':0x47},{'field':'UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(whatsapp_interactions.createdAt)','alias':_0x577ef0('0xb5'),'function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x47},{'field':_0x577ef0('0x2c'),'alias':'AVG\x20Interaction\x20Time','format':'SEC_TO_TIME','custom':!![],'ReportId':0x47},{'field':_0x577ef0('0x3a'),'alias':_0x577ef0('0x134'),'format':_0x577ef0('0x109'),'groupBy':!![],'custom':!![],'ReportId':0x48},{'field':_0x577ef0('0x106'),'alias':'Interactions','function':'COUNT','ReportId':0x48},{'field':'COUNT(IF(closed=1,1,NULL))','alias':'Completed','custom':!![],'ReportId':0x48},{'field':'ROUND(COUNT(IF(closed=1,1,NULL))/COUNT(id)\x20*100,1)','alias':_0x577ef0('0x41'),'custom':!![],'ReportId':0x48},{'field':'UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)','alias':'Interaction\x20Time','function':'SUM','format':'SEC_TO_TIME','custom':!![],'ReportId':0x48},{'field':_0x577ef0('0x50'),'alias':_0x577ef0('0xd6'),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x48},{'field':_0x577ef0('0xe4'),'alias':_0x577ef0('0xcd'),'groupBy':!![],'ReportId':0x49},{'field':'report_whatsapp_queue.id','alias':'Interactions','function':'COUNT','ReportId':0x49},{'field':'COUNT(IF(reason=\x27accepted\x27,1,NULL))','alias':_0x577ef0('0x104'),'custom':!![],'ReportId':0x49},{'field':'COUNT(IF(reason=\x27timeout\x27,1,NULL))','alias':_0x577ef0('0x3e'),'custom':!![],'ReportId':0x49},{'field':_0x577ef0('0x12f'),'alias':_0x577ef0('0xdb'),'function':_0x577ef0('0x130'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x49},{'field':_0x577ef0('0x113'),'alias':_0x577ef0('0x4f'),'format':_0x577ef0('0x63'),'custom':!![],'ReportId':0x49}];return _['groupBy'](_0x155569,_0x577ef0('0x95'));};
\ No newline at end of file