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