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