Built motion from commit f861bcb808219e66da88ba48b61bddb35224a65e. Version 3.0.0...
[motion-next.git] / server / config / seedDB / report / fields.js
index 1dcee39..4b78665 100644 (file)
@@ -1 +1 @@
-'use strict';const a1038_0x2617=['EndTime','NEUTRAL','openchannel_interactions.id','COUNT\x20(IF(voice_recordings.sentiment\x20=\x20\x27POSITIVE\x27,1,NULL))','Abandoned\x2010-60s','SEC_TO_TIME(AVG(talktime))','Total','Unique\x20Id','Mixed(%)','COUNT\x20DISTINCT','QueueExitReason','POSITIVE','Avg\x20Duration','fax_accounts.name','Email\x20Account','CASE\x20WHEN\x20type=\x27TALKING\x27\x20THEN\x20UNIX_TIMESTAMP(exitAt)-UNIX_TIMESTAMP(enterAt)\x20END','Pause\x20Time','queuecallerabandonAt','Campaign\x20Name','Interaction\x20Time','Abandoned>120s','Tag','holdtime','queue','COUNT(IF(closed=1\x20&&\x20disposition\x20=\x27abandoned\x27,1,NULL))','report_openchannel_queue.id','COUNT(IF(closed=0,1,NULL))','data1','acwtime','ROUND(count(id)*100/(SELECT\x20COUNT(*)\x20FROM\x20cm_hopper_history\x20WHERE\x20campaigntype=\x27queue\x27),2)','AVG','queuecallercomplete','AbandonAt','1BuTcOQ','dropreason','calleridname','whatsapp_interactions.createdAt','Abandoned\x20Rate<10s','ROUND(AVG(UNIX_TIMESTAMP(leaveAt)-UNIX_TIMESTAMP(joinAt)))','HOUR','queuecallerexitAt','Event','queuecallerjoinat','whatsapp_accounts.name','Web\x20Site','AvgAbandonTime','CONCAT(ROUND((\x20(SELECT\x20COUNT(IF(voice_recordings.sentiment\x20=\x20\x27POSITIVE\x27,1,NULL)))*100/\x20COUNT\x20(voice_recordings.sentiment)),2),\x27%\x27)','UniqueID','Sms\x20Account','Open','duration','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(mail_interactions.createdAt)))','JoinAt','UnmanagedReason','Project\x20Name','CallerIdNum','Complete','AgentACW','data','chat_websites.name','Source','Calls','type','1nLiCUq','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(whatsapp_interactions.createdAt)','QueueAbandon','Talk\x20Time','Neutral(%)','agentcompleteAt','sms_accounts.name','COUNT(IF(reason=\x27accepted\x27,1,NULL))','COUNT(IF(holdtime\x20>=20\x20AND\x20holdtime\x20<30,1,NULL))','AgentConnectAt','COUNT\x20(IF(voice_recordings.sentiment\x20=\x20\x27MIXED\x27,1,NULL))','queuecallerexitreason','COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20>=120,1,NULL))','ROUND(COUNT(IF(closed=1,1,NULL))/COUNT(id)\x20*100,1)','COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20<10,1,NULL))','source','Answered\x2020-30s','callerid','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(chat_interactions.createdAt)','Offered','LastCallAt','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(chat_interactions.createdAt)))','Abandoned','CASE\x20WHEN\x20queuecallercomplete=1\x20THEN\x20\x27YES\x27\x20ELSE\x20\x27NO\x27\x20END','UNIX_TIMESTAMP(queuecallerExitAt)-UNIX_TIMESTAMP(queuecallerjoinAt)','statedesc','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(mail_interactions.createdAt)','DAY(queuecallerjoinat)','CONCAT(ROUND((\x20(SELECT\x20COUNT(IF(voice_recordings.sentiment\x20=\x20\x27NEUTRAL\x27,1,NULL)))*100/\x20COUNT\x20(voice_recordings.sentiment)),2),\x27%\x27)','LastData','NEGATIVE','sms_queues.name','Answered\x20>30s','1163551sSIGWz','1502763ZOedHh','CompleteAt','Billsec','connectedlinename','Accepted','whatsapp_interactions.closed','Whatsapp\x20Account','agentcalledAt','481012FScydk','3nyxTAM','queuecallerabandon','COUNT\x20(IF(voice_recordings.sentiment\x20=\x20\x27NEUTRAL\x27,1,NULL))','7746KhcKGq','StartTime','CONCAT(ROUND((\x20(SELECT\x20COUNT(IF(voice_recordings.sentiment\x20=\x20\x27MIXED\x27,1,NULL)))*100/\x20COUNT\x20(voice_recordings.sentiment)),2),\x27%\x27)','exitAt','Full\x20Name','UniqueId','Contacts','tag','ROUND(AVG(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)))','UNIX_TIMESTAMP(queuecallercompleteAt)-UNIX_TIMESTAMP(queuecallerleaveAt)','Openchannel\x20Account','mail_interactions.createdAt','ROUND(SUM(queuecallercomplete)/COUNT(DISTINCT\x20uniqueid)*100,1)','uniqueid','BlackList','EnterAt','queuecallerjoinAt','Completed','ROUND(AVG(talktime))','Hold\x20Time','PauseType','SUBSTRING_INDEX(channel,\x20\x22-\x22,\x201)','disposition','Answered\x20<10s','blacklist','LastEvent','ROUND(AVG(duration))','SUM','ROUND(COUNT(IF(holdtime\x20>=10\x20AND\x20holdtime\x20<20,1,NULL))\x20/\x20SUM(agentcomplete)\x20*100,1)','QueuePosition','answertime','billableseconds','MIXED','COUNT(IF(holdtime\x20>=30,1,NULL))','IF(queuecallercomplete=1,holdtime,null)','fax_interactions.closed','Reason','node','DAYNAME(queuecallerjoinat)','AgentExtension','fax_interactions.createdAt','Tot\x20HoldTime','Abandoned\x20Rate\x2060-120s','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)','ROUND(COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20>=120,1,NULL))\x20\x20/\x20SUM(queuecallerabandon)\x20*100,1)','LeaveAt','TotACWTime','openchannel_queues.name','CASE\x20WHEN\x20type=\x27PAUSE\x27\x20THEN\x20UNIX_TIMESTAMP(exitAt)-UNIX_TIMESTAMP(enterAt)\x20END','Type','starttime','chat_interactions.id','AnswerTime','exten','voice_recordings.sentiment','ROUND(COUNT(IF(closed=1\x20&&\x20disposition=\x27abandoned\x27,1,NULL))/COUNT(id)\x20*100,1)','Answer\x20Rate\x2010-20s','COUNT(IF(holdtime\x20>=10\x20AND\x20holdtime\x20<20,1,NULL))','queuecallerleaveAt','DATE','Date','COUNT(IF(reason=\x27timeout\x27,1,NULL))','report_mail_queue.id','COUNT(IF(closed=1,1,NULL))','ExitAt','Interactions','AgentACWTime','COUNT(IF(closed=1\x20&&\x20((disposition\x20!=\x27unmanaged\x27\x20&&\x20disposition\x20!=\x27abandoned\x27)\x20||\x20disposition\x20IS\x20NULL),1,NULL))','657493GHMOlA','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)))','lastapplication','sms_interactions.id','reason','Tot\x20TalkTime','ROUND(AVG(acwtime))','Tot\x20ACWTime','ROUND(SUM(IF(state=4,1,0))/COUNT(*)*100,1)','fax_queues.name','CallerId','lodash','Calls\x20(%)','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(openchannel_interactions.createdAt)','Total\x20Calls','COUNT(IF(closed=1\x20&&\x20disposition\x20=\x27unmanaged\x27,1,NULL))','agentcomplete','Sentiment\x20TOT','calleridnum','489sZIvde','report_fax_queue.id','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(fax_interactions.createdAt)))','Tot\x20Duration','Global\x20Count','Fax\x20Account','openchannel_interactions.closed','ROUND(COUNT(IF(holdtime<10,1,NULL))\x20/\x20SUM(agentcomplete)\x20*100,1)','talktime','talktime\x20+\x20acwtime','HoldTime','groupBy','Unmanaged','CASE\x20WHEN\x20queuecallercomplete=1\x20THEN\x20queuecallercompleteAt\x20ELSE\x20queuecallerLeaveAt\x20END','Completed\x20(%)','DID','COUNT(IF(holdtime<10,1,NULL))','agentconnectAt','706761YEtBJv','Data','chat_interactions.createdAt','lastevent','joinAt','Tot\x20Handle\x20Time','Disposition','enterAt','Hour','Closed','UNIX_TIMESTAMP(exitAt)-UNIX_TIMESTAMP(enterAt)','chat_interactions.closed','AVG\x20Talk\x20Time','Avg\x20Unmanaged\x20TIme','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(whatsapp_interactions.createdAt)))','1ltEVQc','AgentComplete','project_name','ROUND(SUM(talktime\x20+\x20acwtime)/COUNT(agentcomplete))','report_whatsapp_queue.id','End\x20Time','TalkTime','SUM(IF(state=4,1,0))','Answered','endtime','Interface','Avg\x20ACWTime','Answered\x2010-20s','queuecallercompleteAt','AvgTalkTime','Agent','mail_accounts.name','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)','campaign','whatsapp_interactions.id','AgentCalledAt','accountcode','QueueLeaveAt','Negative(%)','TotHandleTime','State','countglobal','rating','Positive(%)','UNIX_TIMESTAMP(leaveAt)-UNIX_TIMESTAMP(joinAt)','Tot\x20Answered','Answer\x20Rate\x20<10s','ROUND(AVG(holdtime))','Timeout','lastdata','agentacw','Abandoned\x20(%)','HangupReason','1dBxCXR','Destination','report_sms_queue.id','whatsapp_queues.name','Total\x20(%)','Recorded\x20Calls','UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)','UserId','openchannel_accounts.name','DayOfWeek','Abandoned\x2060-120s','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(openchannel_interactions.createdAt)))','ROUND(AVG(UNIX_TIMESTAMP(queuecallerExitAt)-UNIX_TIMESTAMP(queuecallerjoinAt)))','ListId','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(sms_interactions.createdAt)','destination','Block','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)','Abandon\x20Time','Abandoned<10s','Penetration\x20Rate','Queue','AVG\x20Interaction\x20Time','AbandonTime','COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20>=60\x20AND\x20UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20<120,1,NULL))','Tot\x20AbandonTime','CONCAT(ROUND((\x20(SELECT\x20COUNT(IF(voice_recordings.sentiment\x20=\x20\x27NEGATIVE\x27,1,NULL)))*100/\x20COUNT\x20(voice_recordings.sentiment)),2),\x27%\x27)','AVG\x20Hold\x20Time','1510031WHaNfE','DestChannel','Rated\x20Calls','Answer\x20Rate','Unmanaged\x20(%)','COUNT','Tot\x20Unmanaged\x20Time','membername','Drop\x20Reason','ROUND(COUNT(IF(closed=1\x20&&\x20disposition=\x27unmanaged\x27,1,NULL))/COUNT(id)\x20*100,1)','Abandon','Total\x20Rating','Duration','AvgHandleTime','Avg\x20Rating','ROUND(AVG(UNIX_TIMESTAMP(queuecallercompleteAt)-UNIX_TIMESTAMP(queuecallerleaveAt)))','report_chat_queue.id','SEC_TO_TIME','QueueJoinAt','ASC','queuecallerexit','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(sms_interactions.createdAt)))','QueueExit','fax_interactions.id','Abandoned\x20Rate\x2010-60s','users.fullname'];const a1038_0x2651=function(_0x32afc3,_0x388404){_0x32afc3=_0x32afc3-0xda;let _0x2617a5=a1038_0x2617[_0x32afc3];return _0x2617a5;};const a1038_0xc6d3e4=a1038_0x2651;(function(_0x575fd6,_0x5d7625){const _0x3e8532=a1038_0x2651;while(!![]){try{const _0x4ffe7d=parseInt(_0x3e8532(0x16e))*parseInt(_0x3e8532(0x13a))+parseInt(_0x3e8532(0x15f))+parseInt(_0x3e8532(0x209))*parseInt(_0x3e8532(0x1b0))+-parseInt(_0x3e8532(0xe9))*parseInt(_0x3e8532(0x1eb))+parseInt(_0x3e8532(0x194))*parseInt(_0x3e8532(0xea))+-parseInt(_0x3e8532(0xf2))*-parseInt(_0x3e8532(0xf3))+-parseInt(_0x3e8532(0x14d))*parseInt(_0x3e8532(0xf6));if(_0x4ffe7d===_0x5d7625)break;else _0x575fd6['push'](_0x575fd6['shift']());}catch(_0x152cef){_0x575fd6['push'](_0x575fd6['shift']());}}}(a1038_0x2617,0xd4183));const _=require(a1038_0xc6d3e4(0x145));module['exports']=function(){const _0x2d25d4=a1038_0xc6d3e4,_0xd4ccbb=[{'field':_0x2d25d4(0x103),'alias':_0x2d25d4(0xfb),'ReportId':0x1},{'field':_0x2d25d4(0x14c),'alias':_0x2d25d4(0x201),'ReportId':0x1},{'field':_0x2d25d4(0x1ed),'alias':'CallerIdName','ReportId':0x1},{'field':_0x2d25d4(0x1e1),'alias':_0x2d25d4(0x1a9),'ReportId':0x1},{'field':'queuecallerjoinAt','alias':_0x2d25d4(0x1c2),'ReportId':0x1},{'field':_0x2d25d4(0x130),'alias':_0x2d25d4(0x184),'ReportId':0x1},{'field':_0x2d25d4(0xf4),'alias':_0x2d25d4(0x20b),'ReportId':0x1},{'field':'queuecallerabandonAt','alias':'QueueAbandonAt','ReportId':0x1},{'field':_0x2d25d4(0x1e9),'alias':_0x2d25d4(0x202),'ReportId':0x1},{'field':_0x2d25d4(0x17b),'alias':_0x2d25d4(0xeb),'ReportId':0x1},{'field':_0x2d25d4(0x1c4),'alias':_0x2d25d4(0x1c6),'ReportId':0x1},{'field':_0x2d25d4(0x1f2),'alias':'QueueExitAt','ReportId':0x1},{'field':_0x2d25d4(0x214),'alias':_0x2d25d4(0x1d4),'ReportId':0x1},{'field':_0x2d25d4(0x12b),'alias':_0x2d25d4(0x15c),'ReportId':0x1},{'field':_0x2d25d4(0xff),'alias':_0x2d25d4(0x174),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0x1},{'field':_0x2d25d4(0x19a),'alias':_0x2d25d4(0x1ab),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0x1},{'field':_0x2d25d4(0x118),'alias':_0x2d25d4(0x12a),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0x1},{'field':_0x2d25d4(0x14c),'alias':'CallerID','ReportId':0x2},{'field':_0x2d25d4(0x1e1),'alias':'Queue','ReportId':0x2},{'field':_0x2d25d4(0x106),'alias':_0x2d25d4(0xf7),'ReportId':0x2},{'field':_0x2d25d4(0x15a),'alias':_0x2d25d4(0x1ca),'custom':0x1,'ReportId':0x2},{'field':_0x2d25d4(0x1e0),'alias':_0x2d25d4(0x157),'format':_0x2d25d4(0x1c1),'ReportId':0x2},{'field':_0x2d25d4(0xdf),'alias':_0x2d25d4(0x176),'custom':0x1,'ReportId':0x2},{'field':_0x2d25d4(0x103),'alias':_0x2d25d4(0xfb),'ReportId':0x3},{'field':'calleridnum','alias':'CallerIdNum','ReportId':0x3},{'field':'calleridname','alias':'CallerIdName','ReportId':0x3},{'field':_0x2d25d4(0x1e1),'alias':_0x2d25d4(0x1a9),'ReportId':0x3},{'field':'membername','alias':_0x2d25d4(0x17d),'ReportId':0x3},{'field':_0x2d25d4(0xf1),'alias':_0x2d25d4(0x182),'ReportId':0x3},{'field':_0x2d25d4(0x15e),'alias':_0x2d25d4(0x212),'ReportId':0x3},{'field':_0x2d25d4(0x20e),'alias':'AgentCompleteAt','ReportId':0x3},{'field':'holdtime','alias':_0x2d25d4(0x12a),'ReportId':0x3},{'field':_0x2d25d4(0x155),'alias':_0x2d25d4(0x174),'ReportId':0x3},{'field':_0x2d25d4(0x191),'alias':_0x2d25d4(0x203),'ReportId':0x3},{'field':'acwtime','alias':_0x2d25d4(0x138),'ReportId':0x3},{'field':_0x2d25d4(0x14a),'alias':_0x2d25d4(0x16f),'ReportId':0x3},{'field':_0x2d25d4(0x13e),'alias':_0x2d25d4(0x193),'ReportId':0x3},{'field':_0x2d25d4(0x162),'alias':_0x2d25d4(0x10f),'ReportId':0x3},{'field':_0x2d25d4(0x12b),'alias':_0x2d25d4(0x15c),'ReportId':0x3},{'field':_0x2d25d4(0x1b7),'alias':_0x2d25d4(0x17d),'groupBy':0x1,'ReportId':0x4},{'field':'agentcomplete','alias':_0x2d25d4(0x107),'function':_0x2d25d4(0x111),'ReportId':0x4},{'field':_0x2d25d4(0x155),'alias':'TotTalkTime','function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'ReportId':0x4},{'field':_0x2d25d4(0x1e6),'alias':_0x2d25d4(0x124),'function':'SUM','format':_0x2d25d4(0x1c1),'ReportId':0x4},{'field':'talktime\x20+\x20acwtime','alias':_0x2d25d4(0x186),'function':'SUM','format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0x4},{'field':_0x2d25d4(0x108),'alias':'AvgTalkTime','format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0x4},{'field':_0x2d25d4(0x140),'alias':'AvgACWTime','format':'SEC_TO_TIME','custom':0x1,'ReportId':0x4},{'field':_0x2d25d4(0x171),'alias':_0x2d25d4(0x1bd),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0x4},{'field':'queue','alias':_0x2d25d4(0x1a9),'groupBy':0x1,'ReportId':0x5},{'field':_0x2d25d4(0x14a),'alias':_0x2d25d4(0x107),'function':'SUM','ReportId':0x5},{'field':_0x2d25d4(0x155),'alias':_0x2d25d4(0x13f),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'ReportId':0x5},{'field':_0x2d25d4(0x1e0),'alias':_0x2d25d4(0x11f),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'ReportId':0x5},{'field':_0x2d25d4(0x1e6),'alias':_0x2d25d4(0x141),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'ReportId':0x5},{'field':_0x2d25d4(0x156),'alias':_0x2d25d4(0x164),'function':'SUM','format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0x5},{'field':'ROUND(AVG(talktime))','alias':'Avg\x20TalkTime','format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0x5},{'field':_0x2d25d4(0x18e),'alias':'Avg\x20HoldTime','format':'SEC_TO_TIME','custom':0x1,'ReportId':0x5},{'field':_0x2d25d4(0x140),'alias':_0x2d25d4(0x179),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0x5},{'field':'ROUND(SUM(talktime\x20+\x20acwtime)/COUNT(agentcomplete))','alias':'Avg\x20Handle\x20Time','format':'SEC_TO_TIME','custom':0x1,'ReportId':0x5},{'field':_0x2d25d4(0x1e1),'alias':_0x2d25d4(0x1a9),'groupBy':0x1,'ReportId':0x6},{'field':_0x2d25d4(0x14a),'alias':_0x2d25d4(0x18c),'function':_0x2d25d4(0x111),'ReportId':0x6},{'field':_0x2d25d4(0x15d),'alias':_0x2d25d4(0x10d),'custom':0x1,'ReportId':0x6},{'field':_0x2d25d4(0x154),'alias':_0x2d25d4(0x18d),'custom':0x1,'ReportId':0x6},{'field':_0x2d25d4(0x12f),'alias':_0x2d25d4(0x17a),'custom':0x1,'ReportId':0x6},{'field':_0x2d25d4(0x112),'alias':_0x2d25d4(0x12e),'custom':0x1,'ReportId':0x6},{'field':_0x2d25d4(0x211),'alias':_0x2d25d4(0x219),'custom':0x1,'ReportId':0x6},{'field':'ROUND(COUNT(IF(holdtime\x20>=20\x20AND\x20holdtime\x20<30,1,NULL))\x20/\x20SUM(agentcomplete)\x20*100,1)','alias':'Answer\x20Rate\x2020-30s','custom':0x1,'ReportId':0x6},{'field':_0x2d25d4(0x117),'alias':_0x2d25d4(0xe8),'custom':0x1,'ReportId':0x6},{'field':'ROUND(COUNT(IF(holdtime\x20>=30,1,NULL))\x20/\x20SUM(agentcomplete)\x20*100,1)','alias':'Answer\x20Rate\x20>30s','custom':0x1,'ReportId':0x6},{'field':_0x2d25d4(0x13e),'alias':_0x2d25d4(0x11a),'groupBy':0x1,'ReportId':0x7},{'field':'uniqueid','alias':_0x2d25d4(0x207),'function':_0x2d25d4(0x1b5),'ReportId':0x7},{'field':'agentconnectAt','alias':'Hour','format':_0x2d25d4(0x1f1),'groupBy':0x1,'ReportId':0x8},{'field':'agentcomplete','alias':_0x2d25d4(0x18c),'function':'SUM','ReportId':0x8},{'field':_0x2d25d4(0x15d),'alias':_0x2d25d4(0x10d),'custom':0x1,'ReportId':0x8},{'field':_0x2d25d4(0x12f),'alias':_0x2d25d4(0x17a),'custom':0x1,'ReportId':0x8},{'field':'COUNT(IF(holdtime\x20>=20\x20AND\x20holdtime\x20<30,1,NULL))','alias':_0x2d25d4(0x219),'custom':0x1,'ReportId':0x8},{'field':_0x2d25d4(0x117),'alias':_0x2d25d4(0xe8),'custom':0x1,'ReportId':0x8},{'field':_0x2d25d4(0x103),'alias':_0x2d25d4(0xfb),'ReportId':0x9},{'field':'calleridnum','alias':_0x2d25d4(0x201),'ReportId':0x9},{'field':_0x2d25d4(0x1e1),'alias':_0x2d25d4(0x1a9),'ReportId':0x9},{'field':'queuecallerjoinAt','alias':_0x2d25d4(0x1fe),'ReportId':0x9},{'field':_0x2d25d4(0x130),'alias':_0x2d25d4(0x123),'ReportId':0x9},{'field':_0x2d25d4(0xf4),'alias':_0x2d25d4(0x1ba),'ReportId':0x9},{'field':_0x2d25d4(0x1db),'alias':_0x2d25d4(0x1ea),'ReportId':0x9},{'field':_0x2d25d4(0x1c4),'alias':_0x2d25d4(0x159),'ReportId':0x9},{'field':_0x2d25d4(0x1f2),'alias':'UnmanagedAt','ReportId':0x9},{'field':_0x2d25d4(0x214),'alias':_0x2d25d4(0x1ff),'ReportId':0x9},{'field':'position','alias':_0x2d25d4(0x113),'ReportId':0x9},{'field':_0x2d25d4(0x12b),'alias':_0x2d25d4(0x15c),'ReportId':0x9},{'field':_0x2d25d4(0x19a),'alias':_0x2d25d4(0x1a6),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0x9},{'field':_0x2d25d4(0xe0),'alias':'Unmanaged\x20HoldTime','format':'SEC_TO_TIME','custom':0x1,'ReportId':0x9},{'field':_0x2d25d4(0x1e1),'alias':_0x2d25d4(0x1a9),'groupBy':0x1,'ReportId':0xa},{'field':'queuecallerabandon','alias':'Abandoned','function':_0x2d25d4(0x111),'ReportId':0xa},{'field':'queuecallerexit','alias':_0x2d25d4(0x159),'function':_0x2d25d4(0x111),'ReportId':0xa},{'field':_0x2d25d4(0x19a),'alias':_0x2d25d4(0x1ad),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0xa},{'field':'ROUND(AVG(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)))','alias':_0x2d25d4(0x1f7),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0xa},{'field':_0x2d25d4(0xe0),'alias':_0x2d25d4(0x1b6),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0xa},{'field':_0x2d25d4(0x1a0),'alias':_0x2d25d4(0x16c),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0xa},{'field':'queuecallerexitreason','alias':'Reason','groupBy':0x1,'ReportId':0xb},{'field':_0x2d25d4(0x1c4),'alias':'Calls','function':'SUM','ReportId':0xb},{'field':_0x2d25d4(0xe0),'alias':_0x2d25d4(0x1b6),'function':_0x2d25d4(0x111),'custom':0x1,'ReportId':0xb},{'field':_0x2d25d4(0x1e1),'alias':_0x2d25d4(0x1a9),'groupBy':0x1,'ReportId':0xc},{'field':'queuecallerabandon','alias':'Tot\x20Abandoned','function':_0x2d25d4(0x111),'ReportId':0xc},{'field':_0x2d25d4(0x217),'alias':_0x2d25d4(0x1a7),'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':_0x2d25d4(0x1ef),'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':_0x2d25d4(0x1ce),'custom':0x1,'ReportId':0xc},{'field':_0x2d25d4(0x1a5),'alias':_0x2d25d4(0x1c8),'custom':0x1,'ReportId':0xc},{'field':_0x2d25d4(0x1ac),'alias':_0x2d25d4(0x19e),'custom':0x1,'ReportId':0xc},{'field':_0x2d25d4(0x17f),'alias':_0x2d25d4(0x120),'custom':0x1,'ReportId':0xc},{'field':_0x2d25d4(0x215),'alias':_0x2d25d4(0x1de),'custom':0x1,'ReportId':0xc},{'field':_0x2d25d4(0x122),'alias':'Abandoned\x20Rate>120s','custom':0x1,'ReportId':0xc},{'field':_0x2d25d4(0x1f4),'alias':_0x2d25d4(0x132),'format':_0x2d25d4(0x131),'groupBy':0x1,'custom':0x1,'ReportId':0xd},{'field':_0x2d25d4(0x103),'alias':_0x2d25d4(0xdb),'function':_0x2d25d4(0x1d3),'ReportId':0xd},{'field':_0x2d25d4(0x1e9),'alias':'Completed','function':_0x2d25d4(0x111),'ReportId':0xd},{'field':'queuecallerabandon','alias':_0x2d25d4(0xde),'function':_0x2d25d4(0x111),'custom':0x1,'ReportId':0xd},{'field':_0x2d25d4(0x1c4),'alias':_0x2d25d4(0x159),'function':_0x2d25d4(0x111),'custom':0x1,'ReportId':0xd},{'field':_0x2d25d4(0xff),'alias':_0x2d25d4(0x13f),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0xd},{'field':_0x2d25d4(0x1bf),'alias':_0x2d25d4(0x17c),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0xd},{'field':_0x2d25d4(0xfe),'alias':'AvgAbandonTime','format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0xd},{'field':'queuecallerjoinat','alias':_0x2d25d4(0x167),'format':'HOUR','groupBy':0x1,'custom':0x1,'ReportId':0xe},{'field':_0x2d25d4(0x103),'alias':_0x2d25d4(0xdb),'function':_0x2d25d4(0x1d3),'ReportId':0xe},{'field':_0x2d25d4(0x1e9),'alias':_0x2d25d4(0x176),'function':_0x2d25d4(0x111),'ReportId':0xe},{'field':_0x2d25d4(0x102),'alias':_0x2d25d4(0x1b3),'custom':0x1,'ReportId':0xe},{'field':_0x2d25d4(0xf4),'alias':_0x2d25d4(0xde),'function':'SUM','ReportId':0xe},{'field':_0x2d25d4(0x1c4),'alias':_0x2d25d4(0x159),'function':_0x2d25d4(0x111),'ReportId':0xe},{'field':_0x2d25d4(0xff),'alias':_0x2d25d4(0x13f),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0xe},{'field':_0x2d25d4(0x1bf),'alias':_0x2d25d4(0x17c),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0xe},{'field':_0x2d25d4(0xfe),'alias':_0x2d25d4(0x1f7),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0xe},{'field':_0x2d25d4(0xe3),'alias':'Day','groupBy':0x1,'custom':0x1,'ReportId':0xf},{'field':_0x2d25d4(0x103),'alias':'Offered','function':_0x2d25d4(0x1d3),'ReportId':0xf},{'field':_0x2d25d4(0x1e9),'alias':'Answered','function':'SUM','ReportId':0xf},{'field':_0x2d25d4(0x102),'alias':_0x2d25d4(0x1b3),'custom':0x1,'ReportId':0xf},{'field':_0x2d25d4(0xf4),'alias':'Abandoned','function':'SUM','ReportId':0xf},{'field':'queuecallerexit','alias':_0x2d25d4(0x159),'function':_0x2d25d4(0x111),'ReportId':0xf},{'field':_0x2d25d4(0xff),'alias':_0x2d25d4(0x13f),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0xf},{'field':_0x2d25d4(0x1bf),'alias':_0x2d25d4(0x17c),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0xf},{'field':'ROUND(AVG(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)))','alias':_0x2d25d4(0x1f7),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0xf},{'field':_0x2d25d4(0x11c),'alias':_0x2d25d4(0x19d),'groupBy':0x1,'custom':0x1,'ReportId':0x10},{'field':_0x2d25d4(0x103),'alias':_0x2d25d4(0xdb),'function':_0x2d25d4(0x1d3),'ReportId':0x10},{'field':_0x2d25d4(0x1e9),'alias':_0x2d25d4(0x176),'function':_0x2d25d4(0x111),'ReportId':0x10},{'field':_0x2d25d4(0x102),'alias':_0x2d25d4(0x1b3),'custom':0x1,'ReportId':0x10},{'field':'queuecallerabandon','alias':_0x2d25d4(0xde),'function':_0x2d25d4(0x111),'orderBy':_0x2d25d4(0x1c3),'ReportId':0x10},{'field':_0x2d25d4(0x1c4),'alias':_0x2d25d4(0x159),'function':'SUM','ReportId':0x10},{'field':_0x2d25d4(0xff),'alias':_0x2d25d4(0x13f),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0x10},{'field':'ROUND(AVG(UNIX_TIMESTAMP(queuecallercompleteAt)-UNIX_TIMESTAMP(queuecallerleaveAt)))','alias':_0x2d25d4(0x17c),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0x10},{'field':_0x2d25d4(0xfe),'alias':_0x2d25d4(0x1f7),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0x10},{'field':'queue','alias':'Queue','groupBy':0x1,'ReportId':0x11},{'field':'uniqueid','alias':_0x2d25d4(0xdb),'function':_0x2d25d4(0x1d3),'ReportId':0x11},{'field':'queuecallercomplete','alias':_0x2d25d4(0x176),'function':_0x2d25d4(0x111),'ReportId':0x11},{'field':_0x2d25d4(0x102),'alias':'Answer\x20Rate','custom':0x1,'ReportId':0x11},{'field':_0x2d25d4(0xf4),'alias':'Abandoned','function':_0x2d25d4(0x111),'ReportId':0x11},{'field':'queuecallerexit','alias':_0x2d25d4(0x159),'function':'SUM','ReportId':0x11},{'field':_0x2d25d4(0xff),'alias':'Tot\x20TalkTime','function':'SUM','format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0x11},{'field':_0x2d25d4(0x1bf),'alias':_0x2d25d4(0x17c),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0x11},{'field':_0x2d25d4(0xfe),'alias':_0x2d25d4(0x1f7),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0x11},{'field':_0x2d25d4(0x103),'alias':_0x2d25d4(0x1f9),'ReportId':0x12},{'field':_0x2d25d4(0x208),'alias':_0x2d25d4(0x127),'ReportId':0x12},{'field':_0x2d25d4(0xfd),'alias':_0x2d25d4(0x1df),'ReportId':0x12},{'field':'source','alias':_0x2d25d4(0x206),'ReportId':0x12},{'field':_0x2d25d4(0x1a3),'alias':_0x2d25d4(0x195),'ReportId':0x12},{'field':'callerid','alias':'CallerID','ReportId':0x12},{'field':'destinationchannel','alias':_0x2d25d4(0x1b1),'ReportId':0x12},{'field':_0x2d25d4(0x13c),'alias':'LastApp','ReportId':0x12},{'field':_0x2d25d4(0x190),'alias':_0x2d25d4(0xe5),'ReportId':0x12},{'field':_0x2d25d4(0x128),'alias':_0x2d25d4(0xf7),'ReportId':0x12},{'field':_0x2d25d4(0x114),'alias':_0x2d25d4(0x12a),'ReportId':0x12},{'field':'endtime','alias':_0x2d25d4(0x1ca),'ReportId':0x12},{'field':_0x2d25d4(0x1fc),'alias':_0x2d25d4(0x1bc),'ReportId':0x12},{'field':'disposition','alias':_0x2d25d4(0x165),'ReportId':0x12},{'field':_0x2d25d4(0x103),'alias':'UniqueID','ReportId':0x13},{'field':_0x2d25d4(0x183),'alias':_0x2d25d4(0x11d),'ReportId':0x13},{'field':_0x2d25d4(0x218),'alias':_0x2d25d4(0x206),'ReportId':0x13},{'field':_0x2d25d4(0x1a3),'alias':'Destination','ReportId':0x13},{'field':_0x2d25d4(0x21a),'alias':_0x2d25d4(0x144),'ReportId':0x13},{'field':'starttime','alias':_0x2d25d4(0xf7),'ReportId':0x13},{'field':_0x2d25d4(0x114),'alias':_0x2d25d4(0x12a),'ReportId':0x13},{'field':_0x2d25d4(0x177),'alias':_0x2d25d4(0x1ca),'ReportId':0x13},{'field':_0x2d25d4(0x1fc),'alias':_0x2d25d4(0x1bc),'format':'SEC_TO_TIME','ReportId':0x13},{'field':_0x2d25d4(0x115),'alias':_0x2d25d4(0xec),'format':_0x2d25d4(0x1c1),'ReportId':0x13},{'field':'disposition','alias':_0x2d25d4(0x165),'ReportId':0x13},{'field':_0x2d25d4(0xfd),'alias':'Tag','ReportId':0x13},{'field':_0x2d25d4(0x208),'alias':'Type','groupBy':0x1,'ReportId':0x14},{'field':_0x2d25d4(0x103),'alias':'Calls','function':_0x2d25d4(0x1b5),'ReportId':0x14},{'field':_0x2d25d4(0x1fc),'alias':_0x2d25d4(0x150),'function':_0x2d25d4(0x111),'format':'SEC_TO_TIME','ReportId':0x14},{'field':'ROUND(AVG(duration))','alias':_0x2d25d4(0x1d6),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0x14},{'field':_0x2d25d4(0x10c),'alias':_0x2d25d4(0x165),'groupBy':0x1,'ReportId':0x15},{'field':_0x2d25d4(0x103),'alias':_0x2d25d4(0x207),'function':_0x2d25d4(0x1b5),'ReportId':0x15},{'field':'duration','alias':'Tot\x20Duration','function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'ReportId':0x15},{'field':_0x2d25d4(0x110),'alias':_0x2d25d4(0x1d6),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0x15},{'field':_0x2d25d4(0x10b),'alias':_0x2d25d4(0x17d),'groupBy':0x1,'custom':0x1,'ReportId':0x16},{'field':_0x2d25d4(0x103),'alias':_0x2d25d4(0x207),'function':_0x2d25d4(0x1b5),'ReportId':0x16},{'field':_0x2d25d4(0x1fc),'alias':_0x2d25d4(0x150),'function':_0x2d25d4(0x111),'format':'SEC_TO_TIME','ReportId':0x16},{'field':_0x2d25d4(0x110),'alias':_0x2d25d4(0x1d6),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0x16},{'field':_0x2d25d4(0x128),'alias':'Date','format':_0x2d25d4(0x131),'groupBy':0x1,'ReportId':0x17},{'field':_0x2d25d4(0x103),'alias':_0x2d25d4(0x207),'function':'COUNT','ReportId':0x17},{'field':_0x2d25d4(0x1fc),'alias':_0x2d25d4(0x150),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'ReportId':0x17},{'field':'ROUND(AVG(duration))','alias':_0x2d25d4(0x1d6),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0x17},{'field':'membername','alias':_0x2d25d4(0x17d),'groupBy':0x1,'orderBy':_0x2d25d4(0x1c3),'ReportId':0x18},{'field':_0x2d25d4(0x169),'alias':_0x2d25d4(0x1bc),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0x18},{'field':_0x2d25d4(0x1b7),'alias':_0x2d25d4(0x17d),'groupBy':0x1,'ReportId':0x19},{'field':'CASE\x20WHEN\x20type=\x27LOGIN\x27\x20THEN\x20UNIX_TIMESTAMP(exitAt)-UNIX_TIMESTAMP(enterAt)\x20END','alias':'Login\x20Time','function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0x19},{'field':_0x2d25d4(0x1d9),'alias':_0x2d25d4(0x20c),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0x19},{'field':_0x2d25d4(0x126),'alias':_0x2d25d4(0x1da),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0x19},{'field':'membername','alias':_0x2d25d4(0x17d),'ReportId':0x1a},{'field':'enterAt','alias':_0x2d25d4(0x105),'ReportId':0x1a},{'field':_0x2d25d4(0xf9),'alias':'ExitAt','ReportId':0x1a},{'field':_0x2d25d4(0x1e5),'alias':'Pause','ReportId':0x1a},{'field':_0x2d25d4(0x1fc),'alias':'Duration','format':_0x2d25d4(0x1c1),'ReportId':0x1a},{'field':'membername','alias':_0x2d25d4(0x17d),'ReportId':0x1b},{'field':'interface','alias':_0x2d25d4(0x178),'ReportId':0x1b},{'field':_0x2d25d4(0x208),'alias':_0x2d25d4(0x1f3),'ReportId':0x1b},{'field':'data1','alias':_0x2d25d4(0x127),'ReportId':0x1b},{'field':_0x2d25d4(0x166),'alias':'EnterAt','ReportId':0x1b},{'field':_0x2d25d4(0xf9),'alias':_0x2d25d4(0x136),'ReportId':0x1b},{'field':_0x2d25d4(0x169),'alias':_0x2d25d4(0x1bc),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0x1b},{'field':_0x2d25d4(0x1b7),'alias':'Agent','groupBy':0x1,'orderBy':_0x2d25d4(0x1c3),'ReportId':0x1c},{'field':_0x2d25d4(0x1e5),'alias':_0x2d25d4(0x10a),'groupBy':0x1,'orderBy':_0x2d25d4(0x1c3),'ReportId':0x1c},{'field':_0x2d25d4(0x169),'alias':_0x2d25d4(0x1bc),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':0x1,'ReportId':0x1c},{'field':'project_name','alias':_0x2d25d4(0x200),'ReportId':0x1d},{'field':_0x2d25d4(0x103),'alias':_0x2d25d4(0xfb),'ReportId':0x1d},{'field':_0x2d25d4(0x21a),'alias':'CallerId','ReportId':0x1d},{'field':'dnid','alias':_0x2d25d4(0x15c),'ReportId':0x1d},{'field':_0x2d25d4(0x163),'alias':'Start\x20Time','orderBy':'ASC','ReportId':0x1d},{'field':'leaveAt','alias':_0x2d25d4(0x173),'ReportId':0x1d},{'field':_0x2d25d4(0x18b),'alias':_0x2d25d4(0x1bc),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0x1d},{'field':_0x2d25d4(0x103),'alias':_0x2d25d4(0x1d1),'ReportId':0x1e},{'field':_0x2d25d4(0x170),'alias':'Project\x20Name','ReportId':0x1e},{'field':'callerid','alias':'Caller\x20Id','ReportId':0x1e},{'field':_0x2d25d4(0x11b),'alias':_0x2d25d4(0x1a4),'ReportId':0x1e},{'field':_0x2d25d4(0x204),'alias':_0x2d25d4(0x160),'ReportId':0x1e},{'field':_0x2d25d4(0xed),'alias':_0x2d25d4(0x17d),'groupBy':0x1,'ReportId':0x1f},{'field':_0x2d25d4(0x103),'alias':_0x2d25d4(0x199),'function':_0x2d25d4(0x1b5),'ReportId':0x1f},{'field':_0x2d25d4(0x189),'alias':_0x2d25d4(0x1bb),'function':'SUM','ReportId':0x1f},{'field':_0x2d25d4(0x189),'alias':_0x2d25d4(0x1be),'function':_0x2d25d4(0x1e8),'ReportId':0x1f},{'field':_0x2d25d4(0x1e1),'alias':_0x2d25d4(0x1a9),'groupBy':0x1,'ReportId':0x20},{'field':_0x2d25d4(0x103),'alias':_0x2d25d4(0x1b2),'function':_0x2d25d4(0x1b5),'ReportId':0x20},{'field':'rating','alias':_0x2d25d4(0x1bb),'function':_0x2d25d4(0x111),'ReportId':0x20},{'field':_0x2d25d4(0x189),'alias':_0x2d25d4(0x1be),'function':_0x2d25d4(0x1e8),'ReportId':0x20},{'field':_0x2d25d4(0x180),'alias':'Campaign\x20Name','ReportId':0x21},{'field':_0x2d25d4(0x14c),'alias':_0x2d25d4(0x201),'ReportId':0x21},{'field':_0x2d25d4(0x128),'alias':'LastCallAt','orderBy':'DESC','ReportId':0x21},{'field':'statedesc','alias':'State','ReportId':0x21},{'field':_0x2d25d4(0x188),'alias':'Global\x20Count','ReportId':0x21},{'field':_0x2d25d4(0x1ec),'alias':_0x2d25d4(0x1b8),'ReportId':0x21},{'field':_0x2d25d4(0x10e),'alias':_0x2d25d4(0x104),'ReportId':0x21},{'field':'membername','alias':_0x2d25d4(0x17d),'ReportId':0x21},{'field':_0x2d25d4(0x155),'alias':'Talk\x20Time','ReportId':0x21},{'field':_0x2d25d4(0x10c),'alias':_0x2d25d4(0x165),'ReportId':0x21},{'field':_0x2d25d4(0x103),'alias':_0x2d25d4(0xfb),'ReportId':0x21},{'field':_0x2d25d4(0xe1),'alias':'State','groupBy':!![],'orderBy':_0x2d25d4(0x1c3),'ReportId':0x22},{'field':'id','alias':_0x2d25d4(0x207),'function':_0x2d25d4(0x1b5),'ReportId':0x22},{'field':_0x2d25d4(0x1e7),'alias':_0x2d25d4(0x146),'custom':!![],'ReportId':0x22},{'field':_0x2d25d4(0x180),'alias':_0x2d25d4(0x1dc),'orderBy':'ASC','groupBy':!![],'ReportId':0x23},{'field':_0x2d25d4(0xe1),'alias':_0x2d25d4(0x187),'groupBy':!![],'ReportId':0x23},{'field':'id','alias':_0x2d25d4(0x148),'function':_0x2d25d4(0x1b5),'ReportId':0x23},{'field':_0x2d25d4(0x1a1),'groupBy':!![],'orderBy':_0x2d25d4(0x1c3),'ReportId':0x24},{'field':'id','alias':_0x2d25d4(0xfc),'function':_0x2d25d4(0x1b5),'ReportId':0x24},{'field':_0x2d25d4(0x175),'alias':'Managed','custom':!![],'ReportId':0x24},{'field':'ROUND(SUM(IF(state=4,1,0))/COUNT(*)*100,1)','alias':_0x2d25d4(0x1a8),'custom':!![],'ReportId':0x24},{'field':_0x2d25d4(0x1b7),'alias':_0x2d25d4(0x17d),'groupBy':!![],'orderBy':'ASC','ReportId':0x25},{'field':'id','alias':_0x2d25d4(0x207),'function':_0x2d25d4(0x1b5),'ReportId':0x25},{'field':_0x2d25d4(0x1cf),'alias':_0x2d25d4(0x16b),'custom':!![],'ReportId':0x25},{'field':_0x2d25d4(0x10c),'alias':_0x2d25d4(0x165),'groupBy':!![],'ReportId':0x26},{'field':'id','alias':'Total','function':_0x2d25d4(0x1b5),'ReportId':0x26},{'field':'ROUND(COUNT(id)*100/(SELECT\x20COUNT(*)\x20FROM\x20cm_hopper_final\x20WHERE\x20state=4\x20and\x20campaigntype=\x27queue\x27),2)','alias':_0x2d25d4(0x198),'custom':!![],'ReportId':0x26},{'field':_0x2d25d4(0x1b7),'alias':_0x2d25d4(0x17d),'groupBy':!![],'ReportId':0x27},{'field':_0x2d25d4(0x10c),'alias':_0x2d25d4(0x165),'groupBy':!![],'ReportId':0x27},{'field':'id','alias':_0x2d25d4(0x1d0),'function':_0x2d25d4(0x1b5),'ReportId':0x27},{'field':'ROUND(COUNT(id)*100/(SELECT\x20COUNT(*)\x20FROM\x20cm_hopper_final\x20WHERE\x20state=4\x20and\x20campaigntype=\x27queue\x27),2)','alias':_0x2d25d4(0x198),'custom':!![],'ReportId':0x27},{'field':_0x2d25d4(0x180),'alias':_0x2d25d4(0x1dc),'ReportId':0x28},{'field':_0x2d25d4(0x14c),'alias':_0x2d25d4(0x201),'ReportId':0x28},{'field':_0x2d25d4(0x128),'alias':_0x2d25d4(0xdc),'orderBy':'DESC','ReportId':0x28},{'field':'statedesc','alias':'State','ReportId':0x28},{'field':_0x2d25d4(0x188),'alias':_0x2d25d4(0x151),'ReportId':0x28},{'field':_0x2d25d4(0x1ec),'alias':_0x2d25d4(0x1b8),'ReportId':0x28},{'field':_0x2d25d4(0x10e),'alias':_0x2d25d4(0x104),'ReportId':0x28},{'field':_0x2d25d4(0x155),'alias':_0x2d25d4(0x20c),'ReportId':0x28},{'field':_0x2d25d4(0x103),'alias':_0x2d25d4(0xfb),'ReportId':0x28},{'field':_0x2d25d4(0xe1),'alias':_0x2d25d4(0x187),'groupBy':!![],'orderBy':_0x2d25d4(0x1c3),'ReportId':0x29},{'field':'id','alias':_0x2d25d4(0x207),'function':'COUNT','ReportId':0x29},{'field':'ROUND(count(id)*100/(SELECT\x20COUNT(*)\x20FROM\x20cm_hopper_history\x20WHERE\x20campaigntype=\x27ivr\x27),2)','alias':'Calls\x20(%)','custom':!![],'ReportId':0x29},{'field':_0x2d25d4(0x180),'alias':_0x2d25d4(0x1dc),'orderBy':'ASC','groupBy':!![],'ReportId':0x2a},{'field':_0x2d25d4(0xe1),'alias':_0x2d25d4(0x187),'groupBy':!![],'ReportId':0x2a},{'field':'id','alias':_0x2d25d4(0x148),'function':_0x2d25d4(0x1b5),'ReportId':0x2a},{'field':'ListId','groupBy':!![],'orderBy':_0x2d25d4(0x1c3),'ReportId':0x2b},{'field':'id','alias':_0x2d25d4(0xfc),'function':_0x2d25d4(0x1b5),'ReportId':0x2b},{'field':_0x2d25d4(0x175),'alias':'Managed','custom':!![],'ReportId':0x2b},{'field':_0x2d25d4(0x142),'alias':'Penetration\x20Rate','custom':!![],'ReportId':0x2b},{'field':_0x2d25d4(0x205),'alias':_0x2d25d4(0x1f6),'groupBy':!![],'ReportId':0x2c},{'field':_0x2d25d4(0x129),'alias':'Interactions','function':_0x2d25d4(0x1b5),'ReportId':0x2c},{'field':_0x2d25d4(0x1e4),'alias':_0x2d25d4(0x1fb),'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':_0x2d25d4(0x168),'custom':!![],'ReportId':0x2c},{'field':_0x2d25d4(0x149),'alias':_0x2d25d4(0x159),'custom':!![],'ReportId':0x2c},{'field':'COUNT(IF(closed=1\x20&&\x20disposition\x20=\x27abandoned\x27,1,NULL))','alias':_0x2d25d4(0xde),'custom':!![],'ReportId':0x2c},{'field':'chat_websites.name','alias':_0x2d25d4(0x1f6),'groupBy':!![],'ReportId':0x2d},{'field':_0x2d25d4(0xda),'alias':_0x2d25d4(0x1dd),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x2d},{'field':_0x2d25d4(0xdd),'alias':'AVG\x20Interaction\x20Time','format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x2d},{'field':_0x2d25d4(0x1c9),'alias':_0x2d25d4(0x17d),'groupBy':!![],'ReportId':0x2e},{'field':_0x2d25d4(0x16a),'alias':_0x2d25d4(0x168),'function':_0x2d25d4(0x111),'ReportId':0x2e},{'field':_0x2d25d4(0xda),'alias':'Interaction\x20Time','function':'SUM','format':'SEC_TO_TIME','custom':!![],'ReportId':0x2e},{'field':'ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(chat_interactions.createdAt)))','alias':'AVG\x20Interaction\x20Time','format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x2e},{'field':_0x2d25d4(0x161),'alias':'Date','format':_0x2d25d4(0x131),'groupBy':!![],'custom':!![],'ReportId':0x2f},{'field':'chat_interactions.id','alias':'Interactions','function':_0x2d25d4(0x1b5),'ReportId':0x2f},{'field':_0x2d25d4(0x139),'alias':_0x2d25d4(0x107),'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':_0x2d25d4(0x15b),'custom':!![],'ReportId':0x2f},{'field':_0x2d25d4(0x149),'alias':_0x2d25d4(0x159),'custom':!![],'ReportId':0x2f},{'field':_0x2d25d4(0x1b9),'alias':_0x2d25d4(0x1b4),'custom':!![],'ReportId':0x2f},{'field':_0x2d25d4(0x1e2),'alias':_0x2d25d4(0xde),'custom':!![],'ReportId':0x2f},{'field':_0x2d25d4(0x12d),'alias':_0x2d25d4(0x192),'custom':!![],'ReportId':0x2f},{'field':_0x2d25d4(0x121),'alias':'Interaction\x20Time','function':_0x2d25d4(0x111),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x2f},{'field':_0x2d25d4(0x13b),'alias':_0x2d25d4(0x1aa),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x2f},{'field':'chat_queues.name','alias':_0x2d25d4(0x1a9),'groupBy':!![],'ReportId':0x30},{'field':_0x2d25d4(0x1c0),'alias':'Interactions','function':'COUNT','ReportId':0x30},{'field':_0x2d25d4(0x210),'alias':_0x2d25d4(0xee),'custom':!![],'ReportId':0x30},{'field':_0x2d25d4(0x133),'alias':_0x2d25d4(0x18f),'custom':!![],'ReportId':0x30},{'field':_0x2d25d4(0x18b),'alias':_0x2d25d4(0x109),'function':'SUM','format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x30},{'field':_0x2d25d4(0x1f0),'alias':_0x2d25d4(0x1af),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x30},{'field':_0x2d25d4(0x17e),'alias':_0x2d25d4(0x1d8),'groupBy':!![],'ReportId':0x31},{'field':'mail_interactions.id','alias':_0x2d25d4(0x137),'function':_0x2d25d4(0x1b5),'ReportId':0x31},{'field':_0x2d25d4(0x1e4),'alias':_0x2d25d4(0x1fb),'custom':!![],'ReportId':0x31},{'field':_0x2d25d4(0x135),'alias':'Closed','custom':!![],'ReportId':0x31},{'field':_0x2d25d4(0x17e),'alias':_0x2d25d4(0x1d8),'groupBy':!![],'ReportId':0x32},{'field':_0x2d25d4(0xe2),'alias':'Interaction\x20Time','function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x32},{'field':_0x2d25d4(0x1fd),'alias':_0x2d25d4(0x1aa),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x32},{'field':_0x2d25d4(0x1c9),'alias':'Agent','groupBy':!![],'ReportId':0x33},{'field':'mail_interactions.closed','alias':_0x2d25d4(0x168),'function':'SUM','ReportId':0x33},{'field':_0x2d25d4(0xe2),'alias':_0x2d25d4(0x1dd),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x33},{'field':_0x2d25d4(0x1fd),'alias':'AVG\x20Interaction\x20Time','format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x33},{'field':_0x2d25d4(0x101),'alias':_0x2d25d4(0x132),'format':_0x2d25d4(0x131),'groupBy':!![],'custom':!![],'ReportId':0x34},{'field':'mail_interactions.id','alias':_0x2d25d4(0x137),'function':_0x2d25d4(0x1b5),'ReportId':0x34},{'field':'COUNT(IF(closed=1,1,NULL))','alias':_0x2d25d4(0x107),'custom':!![],'ReportId':0x34},{'field':_0x2d25d4(0x216),'alias':_0x2d25d4(0x15b),'custom':!![],'ReportId':0x34},{'field':_0x2d25d4(0x121),'alias':_0x2d25d4(0x1dd),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x34},{'field':_0x2d25d4(0x13b),'alias':_0x2d25d4(0x1aa),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x34},{'field':'mail_queues.name','alias':_0x2d25d4(0x1a9),'groupBy':!![],'ReportId':0x35},{'field':_0x2d25d4(0x134),'alias':_0x2d25d4(0x137),'function':_0x2d25d4(0x1b5),'ReportId':0x35},{'field':'COUNT(IF(reason=\x27accepted\x27,1,NULL))','alias':_0x2d25d4(0xee),'custom':!![],'ReportId':0x35},{'field':_0x2d25d4(0x133),'alias':_0x2d25d4(0x18f),'custom':!![],'ReportId':0x35},{'field':'UNIX_TIMESTAMP(leaveAt)-UNIX_TIMESTAMP(joinAt)','alias':_0x2d25d4(0x109),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x35},{'field':_0x2d25d4(0x1f0),'alias':_0x2d25d4(0x1af),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x35},{'field':_0x2d25d4(0x19c),'alias':_0x2d25d4(0x100),'groupBy':!![],'ReportId':0x36},{'field':_0x2d25d4(0x1cc),'alias':'Interactions','function':_0x2d25d4(0x1b5),'ReportId':0x36},{'field':_0x2d25d4(0x1e4),'alias':_0x2d25d4(0x1fb),'custom':!![],'ReportId':0x36},{'field':_0x2d25d4(0x135),'alias':_0x2d25d4(0x168),'custom':!![],'ReportId':0x36},{'field':'openchannel_accounts.name','alias':'Openchannel\x20Account','groupBy':!![],'ReportId':0x37},{'field':'UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(openchannel_interactions.createdAt)','alias':_0x2d25d4(0x1dd),'function':'SUM','format':'SEC_TO_TIME','custom':!![],'ReportId':0x37},{'field':'ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(openchannel_interactions.createdAt)))','alias':_0x2d25d4(0x1aa),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x37},{'field':_0x2d25d4(0x1c9),'alias':_0x2d25d4(0x17d),'groupBy':!![],'ReportId':0x38},{'field':_0x2d25d4(0x153),'alias':_0x2d25d4(0x168),'function':'SUM','ReportId':0x38},{'field':_0x2d25d4(0x147),'alias':_0x2d25d4(0x1dd),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x38},{'field':_0x2d25d4(0x19f),'alias':'AVG\x20Interaction\x20Time','format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x38},{'field':'openchannel_interactions.createdAt','alias':_0x2d25d4(0x132),'format':_0x2d25d4(0x131),'groupBy':!![],'custom':!![],'ReportId':0x39},{'field':'openchannel_interactions.id','alias':_0x2d25d4(0x137),'function':_0x2d25d4(0x1b5),'ReportId':0x39},{'field':_0x2d25d4(0x135),'alias':_0x2d25d4(0x107),'custom':!![],'ReportId':0x39},{'field':_0x2d25d4(0x216),'alias':_0x2d25d4(0x15b),'custom':!![],'ReportId':0x39},{'field':_0x2d25d4(0x121),'alias':'Interaction\x20Time','function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x39},{'field':_0x2d25d4(0x13b),'alias':_0x2d25d4(0x1aa),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x39},{'field':_0x2d25d4(0x125),'alias':_0x2d25d4(0x1a9),'groupBy':!![],'ReportId':0x3a},{'field':_0x2d25d4(0x1e3),'alias':'Interactions','function':'COUNT','ReportId':0x3a},{'field':'COUNT(IF(reason=\x27accepted\x27,1,NULL))','alias':_0x2d25d4(0xee),'custom':!![],'ReportId':0x3a},{'field':'COUNT(IF(reason=\x27timeout\x27,1,NULL))','alias':'Timeout','custom':!![],'ReportId':0x3a},{'field':_0x2d25d4(0x18b),'alias':_0x2d25d4(0x109),'function':_0x2d25d4(0x111),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x3a},{'field':_0x2d25d4(0x1f0),'alias':_0x2d25d4(0x1af),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x3a},{'field':_0x2d25d4(0x20f),'alias':_0x2d25d4(0x1fa),'groupBy':!![],'ReportId':0x3b},{'field':_0x2d25d4(0x13d),'alias':_0x2d25d4(0x137),'function':'COUNT','ReportId':0x3b},{'field':_0x2d25d4(0x1e4),'alias':_0x2d25d4(0x1fb),'custom':!![],'ReportId':0x3b},{'field':'COUNT(IF(closed=1,1,NULL))','alias':_0x2d25d4(0x168),'custom':!![],'ReportId':0x3b},{'field':'sms_accounts.name','alias':_0x2d25d4(0x1fa),'groupBy':!![],'ReportId':0x3c},{'field':_0x2d25d4(0x1a2),'alias':_0x2d25d4(0x1dd),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x3c},{'field':_0x2d25d4(0x1c5),'alias':_0x2d25d4(0x1aa),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x3c},{'field':'users.fullname','alias':_0x2d25d4(0x17d),'groupBy':!![],'ReportId':0x3d},{'field':'sms_interactions.closed','alias':_0x2d25d4(0x168),'function':_0x2d25d4(0x111),'ReportId':0x3d},{'field':_0x2d25d4(0x1a2),'alias':'Interaction\x20Time','function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x3d},{'field':'ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(sms_interactions.createdAt)))','alias':_0x2d25d4(0x1aa),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x3d},{'field':'sms_interactions.createdAt','alias':_0x2d25d4(0x132),'format':_0x2d25d4(0x131),'groupBy':!![],'custom':!![],'ReportId':0x3e},{'field':'sms_interactions.id','alias':_0x2d25d4(0x137),'function':_0x2d25d4(0x1b5),'ReportId':0x3e},{'field':_0x2d25d4(0x135),'alias':_0x2d25d4(0x107),'custom':!![],'ReportId':0x3e},{'field':_0x2d25d4(0x216),'alias':'Completed\x20(%)','custom':!![],'ReportId':0x3e},{'field':'UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)','alias':_0x2d25d4(0x1dd),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x3e},{'field':_0x2d25d4(0x13b),'alias':'AVG\x20Interaction\x20Time','format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x3e},{'field':_0x2d25d4(0xe7),'alias':_0x2d25d4(0x1a9),'groupBy':!![],'ReportId':0x3f},{'field':_0x2d25d4(0x196),'alias':_0x2d25d4(0x137),'function':_0x2d25d4(0x1b5),'ReportId':0x3f},{'field':_0x2d25d4(0x210),'alias':_0x2d25d4(0xee),'custom':!![],'ReportId':0x3f},{'field':'COUNT(IF(reason=\x27timeout\x27,1,NULL))','alias':'Timeout','custom':!![],'ReportId':0x3f},{'field':_0x2d25d4(0x18b),'alias':_0x2d25d4(0x109),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x3f},{'field':'ROUND(AVG(UNIX_TIMESTAMP(leaveAt)-UNIX_TIMESTAMP(joinAt)))','alias':'AVG\x20Hold\x20Time','format':'SEC_TO_TIME','custom':!![],'ReportId':0x3f},{'field':_0x2d25d4(0x143),'alias':'Queue','groupBy':!![],'ReportId':0x44},{'field':_0x2d25d4(0x14e),'alias':'Interactions','function':_0x2d25d4(0x1b5),'ReportId':0x44},{'field':_0x2d25d4(0x210),'alias':_0x2d25d4(0xee),'custom':!![],'ReportId':0x44},{'field':_0x2d25d4(0x133),'alias':'Timeout','custom':!![],'ReportId':0x44},{'field':'UNIX_TIMESTAMP(leaveAt)-UNIX_TIMESTAMP(joinAt)','alias':'Hold\x20Time','function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x44},{'field':_0x2d25d4(0x1f0),'alias':_0x2d25d4(0x1af),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x44},{'field':_0x2d25d4(0x11e),'alias':_0x2d25d4(0x132),'format':_0x2d25d4(0x131),'groupBy':!![],'custom':!![],'ReportId':0x43},{'field':'fax_interactions.id','alias':_0x2d25d4(0x137),'function':_0x2d25d4(0x1b5),'ReportId':0x43},{'field':_0x2d25d4(0x135),'alias':_0x2d25d4(0x107),'custom':!![],'ReportId':0x43},{'field':'ROUND(COUNT(IF(closed=1,1,NULL))/COUNT(id)\x20*100,1)','alias':_0x2d25d4(0x15b),'custom':!![],'ReportId':0x43},{'field':'UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)','alias':_0x2d25d4(0x1dd),'function':'SUM','format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x43},{'field':_0x2d25d4(0x13b),'alias':_0x2d25d4(0x1aa),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x43},{'field':_0x2d25d4(0x1c9),'alias':_0x2d25d4(0x17d),'groupBy':!![],'ReportId':0x42},{'field':_0x2d25d4(0x119),'alias':_0x2d25d4(0x168),'function':_0x2d25d4(0x111),'ReportId':0x42},{'field':'UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(fax_interactions.createdAt)','alias':_0x2d25d4(0x1dd),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x42},{'field':_0x2d25d4(0x14f),'alias':_0x2d25d4(0x1aa),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x42},{'field':_0x2d25d4(0x1d7),'alias':'Fax\x20Account','groupBy':!![],'ReportId':0x41},{'field':'UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(fax_interactions.createdAt)','alias':_0x2d25d4(0x1dd),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x41},{'field':_0x2d25d4(0x14f),'alias':_0x2d25d4(0x1aa),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x41},{'field':_0x2d25d4(0x1d7),'alias':_0x2d25d4(0x152),'groupBy':!![],'ReportId':0x40},{'field':_0x2d25d4(0x1c7),'alias':_0x2d25d4(0x137),'function':_0x2d25d4(0x1b5),'ReportId':0x40},{'field':_0x2d25d4(0x1e4),'alias':_0x2d25d4(0x1fb),'custom':!![],'ReportId':0x40},{'field':_0x2d25d4(0x135),'alias':'Closed','custom':!![],'ReportId':0x40},{'field':'voice_recordings.UserId','alias':_0x2d25d4(0x19b),'groupBy':!![],'custom':![],'ReportId':0x4a},{'field':_0x2d25d4(0x1c9),'alias':_0x2d25d4(0xfa),'groupBy':![],'custom':![],'ReportId':0x4a},{'field':'COUNT\x20(IF(voice_recordings.sentiment\x20=\x20\x27POSITIVE\x27,1,NULL))','alias':'POSITIVE','groupBy':![],'custom':!![],'ReportId':0x4a},{'field':'COUNT\x20(IF(voice_recordings.sentiment\x20=\x20\x27NEGATIVE\x27,1,NULL))','alias':_0x2d25d4(0xe6),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x2d25d4(0xf5),'alias':'NEUTRAL','groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x2d25d4(0x213),'alias':_0x2d25d4(0x116),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x2d25d4(0x12c),'alias':'TOT','function':_0x2d25d4(0x1b5),'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':_0x2d25d4(0x18a),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x2d25d4(0x1ae),'alias':_0x2d25d4(0x185),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x2d25d4(0xe4),'alias':_0x2d25d4(0x20d),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x2d25d4(0xf8),'alias':_0x2d25d4(0x1d2),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x2d25d4(0x12c),'alias':_0x2d25d4(0x14b),'function':_0x2d25d4(0x1b5),'groupBy':![],'custom':![],'ReportId':0x4b},{'field':_0x2d25d4(0x1cd),'alias':_0x2d25d4(0x1d5),'groupBy':![],'custom':!![],'ReportId':0x4b},{'field':'COUNT\x20(IF(voice_recordings.sentiment\x20=\x20\x27NEGATIVE\x27,1,NULL))','alias':_0x2d25d4(0xe6),'groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x2d25d4(0xf5),'alias':_0x2d25d4(0x1cb),'groupBy':![],'custom':!![],'ReportId':0x4b},{'field':'COUNT\x20(IF(voice_recordings.sentiment\x20=\x20\x27MIXED\x27,1,NULL))','alias':'MIXED','groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x2d25d4(0x1f8),'alias':_0x2d25d4(0x18a),'groupBy':![],'custom':!![],'ReportId':0x4b},{'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':_0x2d25d4(0x185),'groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x2d25d4(0xe4),'alias':_0x2d25d4(0x20d),'groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x2d25d4(0xf8),'alias':_0x2d25d4(0x1d2),'groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x2d25d4(0x1f5),'alias':_0x2d25d4(0xf0),'groupBy':!![],'ReportId':0x45},{'field':_0x2d25d4(0x181),'alias':_0x2d25d4(0x137),'function':_0x2d25d4(0x1b5),'ReportId':0x45},{'field':_0x2d25d4(0x1e4),'alias':_0x2d25d4(0x1fb),'custom':!![],'ReportId':0x45},{'field':_0x2d25d4(0x135),'alias':_0x2d25d4(0x168),'custom':!![],'ReportId':0x45},{'field':'whatsapp_accounts.name','alias':_0x2d25d4(0xf0),'groupBy':!![],'ReportId':0x46},{'field':_0x2d25d4(0x20a),'alias':_0x2d25d4(0x1dd),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x46},{'field':_0x2d25d4(0x16d),'alias':_0x2d25d4(0x1aa),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x46},{'field':_0x2d25d4(0x1c9),'alias':_0x2d25d4(0x17d),'groupBy':!![],'ReportId':0x47},{'field':_0x2d25d4(0xef),'alias':'Closed','function':_0x2d25d4(0x111),'ReportId':0x47},{'field':_0x2d25d4(0x20a),'alias':_0x2d25d4(0x1dd),'function':'SUM','format':'SEC_TO_TIME','custom':!![],'ReportId':0x47},{'field':_0x2d25d4(0x16d),'alias':_0x2d25d4(0x1aa),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x47},{'field':_0x2d25d4(0x1ee),'alias':_0x2d25d4(0x132),'format':_0x2d25d4(0x131),'groupBy':!![],'custom':!![],'ReportId':0x48},{'field':_0x2d25d4(0x181),'alias':_0x2d25d4(0x137),'function':_0x2d25d4(0x1b5),'ReportId':0x48},{'field':_0x2d25d4(0x135),'alias':_0x2d25d4(0x107),'custom':!![],'ReportId':0x48},{'field':'ROUND(COUNT(IF(closed=1,1,NULL))/COUNT(id)\x20*100,1)','alias':_0x2d25d4(0x15b),'custom':!![],'ReportId':0x48},{'field':_0x2d25d4(0x121),'alias':'Interaction\x20Time','function':'SUM','format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x48},{'field':'ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)))','alias':'AVG\x20Interaction\x20Time','format':'SEC_TO_TIME','custom':!![],'ReportId':0x48},{'field':_0x2d25d4(0x197),'alias':_0x2d25d4(0x1a9),'groupBy':!![],'ReportId':0x49},{'field':_0x2d25d4(0x172),'alias':'Interactions','function':_0x2d25d4(0x1b5),'ReportId':0x49},{'field':_0x2d25d4(0x210),'alias':_0x2d25d4(0xee),'custom':!![],'ReportId':0x49},{'field':'COUNT(IF(reason=\x27timeout\x27,1,NULL))','alias':'Timeout','custom':!![],'ReportId':0x49},{'field':_0x2d25d4(0x18b),'alias':_0x2d25d4(0x109),'function':_0x2d25d4(0x111),'format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x49},{'field':_0x2d25d4(0x1f0),'alias':'AVG\x20Hold\x20Time','format':_0x2d25d4(0x1c1),'custom':!![],'ReportId':0x49}];return _[_0x2d25d4(0x158)](_0xd4ccbb,'ReportId');};
\ No newline at end of file
+'use strict';const a1040_0x27f5=['LastCallAt','ROUND(AVG(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)))','Interface','Total\x20(%)','IF(queuecallercomplete=1,holdtime,null)','Source','COUNT(IF(closed=1\x20&&\x20disposition\x20=\x27unmanaged\x27,1,NULL))','exitAt','Tot\x20HoldTime','Full\x20Name','agentcompleteAt','queuecallerabandonAt','sms_interactions.createdAt','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)','CallerID','Disposition','COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20>=120,1,NULL))','enterAt','Answered\x20<10s','JoinAt','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(openchannel_interactions.createdAt)','Positive(%)','AbandonAt','report_mail_queue.id','Interactions','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(whatsapp_interactions.createdAt)))','Queue','QueueExit','Answer\x20Rate\x20<10s','Duration','Reason','COUNT(IF(reason=\x27accepted\x27,1,NULL))','COUNT(IF(closed=0,1,NULL))','Calls','campaign','HangupReason','Tot\x20TalkTime','accountcode','SUM','queuecallerexitreason','talktime\x20+\x20acwtime','Answered','Negative(%)','lastdata','fax_interactions.createdAt','AVG','Answer\x20Rate\x20>30s','Whatsapp\x20Account','Tot\x20Answered','lastevent','186501iFbeno','Tot\x20Abandoned','SEC_TO_TIME','fax_interactions.closed','DID','AgentACW','Destination','users.fullname','Total','openchannel_interactions.id','CONCAT(ROUND((\x20(SELECT\x20COUNT(IF(voice_recordings.sentiment\x20=\x20\x27MIXED\x27,1,NULL)))*100/\x20COUNT\x20(voice_recordings.sentiment)),2),\x27%\x27)','StartTime','Avg\x20HoldTime','Abandoned\x20Rate\x2010-60s','DayOfWeek','State','countglobal','reason','AVG\x20Hold\x20Time','AvgAbandonTime','Openchannel\x20Account','Caller\x20Id','Fax\x20Account','Total\x20Calls','Campaign\x20Name','Contacts','QueueJoinAt','ROUND(COUNT(IF(holdtime<10,1,NULL))\x20/\x20SUM(agentcomplete)\x20*100,1)','PauseType','AgentCalledAt','lodash','sms_interactions.closed','calleridnum','queuecallerexitAt','destinationchannel','Sentiment\x20TOT','DAYNAME(queuecallerjoinat)','TalkTime','ROUND(count(id)*100/(SELECT\x20COUNT(*)\x20FROM\x20cm_hopper_history\x20WHERE\x20campaigntype=\x27ivr\x27),2)','data1','Unique\x20Id','Completed\x20(%)','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(chat_interactions.createdAt)))','3JaOwbL','joinAt','Agent','chat_interactions.id','COUNT(IF(reason=\x27timeout\x27,1,NULL))','ROUND(AVG(holdtime))','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(fax_interactions.createdAt)','interface','data','COUNT\x20(IF(voice_recordings.sentiment\x20=\x20\x27NEGATIVE\x27,1,NULL))','Abandoned\x20Rate>120s','project_name','HOUR','SUM(IF(state=4,1,0))','MIXED','callerid','lastapplication','1590932hsojIr','Hour','Total\x20Rating','whatsapp_accounts.name','dropreason','ReportId','CONCAT(ROUND((\x20(SELECT\x20COUNT(IF(voice_recordings.sentiment\x20=\x20\x27NEGATIVE\x27,1,NULL)))*100/\x20COUNT\x20(voice_recordings.sentiment)),2),\x27%\x27)','Sms\x20Account','duration','leaveAt','COUNT\x20(IF(voice_recordings.sentiment\x20=\x20\x27NEUTRAL\x27,1,NULL))','QueueExitReason','blacklist','queuecallercompleteAt','Completed','ROUND(AVG(UNIX_TIMESTAMP(queuecallerExitAt)-UNIX_TIMESTAMP(queuecallerjoinAt)))','LeaveAt','type','460466SFxnpm','talktime','starttime','voice_recordings.UserId','destination','CallerIdNum','Interaction\x20Time','Email\x20Account','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(mail_interactions.createdAt)))','rating','Drop\x20Reason','EndTime','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)))','CallerId','tag','COUNT(IF(closed=1,1,NULL))','chat_websites.name','statedesc','whatsapp_queues.name','160581tZWWMF','Calls\x20(%)','Answered\x2010-20s','DESC','LastApp','ASC','exports','ROUND(COUNT(IF(closed=1,1,NULL))/COUNT(id)\x20*100,1)','queuecallerjoinAt','COUNT(IF(holdtime\x20>=10\x20AND\x20holdtime\x20<20,1,NULL))','CallerIdName','whatsapp_interactions.closed','EnterAt','SUBSTRING_INDEX(channel,\x20\x22-\x22,\x201)','UserId','Start\x20Time','Abandoned\x2060-120s','AgentExtension','queuecallerabandon','COUNT(IF(holdtime\x20>=30,1,NULL))','uniqueid','COUNT(IF(closed=1\x20&&\x20((disposition\x20!=\x27unmanaged\x27\x20&&\x20disposition\x20!=\x27abandoned\x27)\x20||\x20disposition\x20IS\x20NULL),1,NULL))','UnmanagedAt','AnswerTime','chat_interactions.closed','Mixed(%)','COUNT(IF(holdtime<10,1,NULL))','UNIX_TIMESTAMP(queuecallercompleteAt)-UNIX_TIMESTAMP(queuecallerleaveAt)','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(chat_interactions.createdAt)','mail_interactions.closed','mail_queues.name','Penetration\x20Rate','NEGATIVE','Answered\x20>30s','Pause','Talk\x20Time','Event','connectedlinename','ROUND(AVG(UNIX_TIMESTAMP(queuecallercompleteAt)-UNIX_TIMESTAMP(queuecallerleaveAt)))','acwtime','AgentACWTime','queuecallerexit','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(sms_interactions.createdAt)))','AgentComplete','AgentConnectAt','ROUND(COUNT(id)*100/(SELECT\x20COUNT(*)\x20FROM\x20cm_hopper_final\x20WHERE\x20state=4\x20and\x20campaigntype=\x27queue\x27),2)','DAY(queuecallerjoinat)','Accepted','Unmanaged','Answer\x20Rate\x2020-30s','Answer\x20Rate','voice_recordings.sentiment','POSITIVE','UniqueId','AVG\x20Interaction\x20Time','ROUND(AVG(acwtime))','Pause\x20Time','NEUTRAL','queuecallercomplete','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)','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)','End\x20Time','fax_queues.name','Tot\x20AbandonTime','CONCAT(ROUND((\x20(SELECT\x20COUNT(IF(voice_recordings.sentiment\x20=\x20\x27NEUTRAL\x27,1,NULL)))*100/\x20COUNT\x20(voice_recordings.sentiment)),2),\x27%\x27)','CASE\x20WHEN\x20queuecallercomplete=1\x20THEN\x20\x27YES\x27\x20ELSE\x20\x27NO\x27\x20END','Avg\x20Unmanaged\x20TIme','calleridname','Avg\x20Rating','ROUND(SUM(IF(state=4,1,0))/COUNT(*)*100,1)','whatsapp_interactions.id','Answered\x2020-30s','ROUND(AVG(UNIX_TIMESTAMP(leaveAt)-UNIX_TIMESTAMP(joinAt)))','4CdQDSx','Abandon\x20Time','Avg\x20TalkTime','ROUND(COUNT(IF(closed=1\x20&&\x20disposition=\x27abandoned\x27,1,NULL))/COUNT(id)\x20*100,1)','billableseconds','CASE\x20WHEN\x20type=\x27PAUSE\x27\x20THEN\x20UNIX_TIMESTAMP(exitAt)-UNIX_TIMESTAMP(enterAt)\x20END','Project\x20Name','openchannel_interactions.createdAt','AVG\x20Talk\x20Time','AvgTalkTime','Rated\x20Calls','Abandoned\x20Rate\x2060-120s','COUNT','Answer\x20Rate\x2010-20s','sms_interactions.id','Date','TotACWTime','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(fax_interactions.createdAt)))','TotTalkTime','Closed','UNIX_TIMESTAMP(leaveAt)-UNIX_TIMESTAMP(joinAt)','agentcomplete','ROUND(SUM(queuecallercomplete)/COUNT(DISTINCT\x20uniqueid)*100,1)','mail_interactions.createdAt','ListId','UniqueID','UNIX_TIMESTAMP(exitAt)-UNIX_TIMESTAMP(enterAt)','COUNT(IF(holdtime\x20>=20\x20AND\x20holdtime\x20<30,1,NULL))','mail_interactions.id','position','ExitAt','queuecallerjoinat','Timeout','endtime','membername','Managed','COUNT\x20DISTINCT','ROUND(COUNT(IF(closed=1\x20&&\x20disposition=\x27unmanaged\x27,1,NULL))/COUNT(id)\x20*100,1)','Tag','COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20>=60\x20AND\x20UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20<120,1,NULL))','3103674BGmHgv','UNIX_TIMESTAMP(queuecallerExitAt)-UNIX_TIMESTAMP(queuecallerjoinAt)','ROUND(COUNT(IF(holdtime\x20>=20\x20AND\x20holdtime\x20<30,1,NULL))\x20/\x20SUM(agentcomplete)\x20*100,1)','Avg\x20Handle\x20Time','Block','Web\x20Site','ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(openchannel_interactions.createdAt)))','AvgHandleTime','Recorded\x20Calls','fax_interactions.id','agentacw','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(whatsapp_interactions.createdAt)','ROUND(AVG(duration))','Unmanaged\x20(%)','DATE','Avg\x20Duration','openchannel_interactions.closed','exten','disposition','DestChannel','mail_accounts.name','Open','LastData','source','CASE\x20WHEN\x20type=\x27TALKING\x27\x20THEN\x20UNIX_TIMESTAMP(exitAt)-UNIX_TIMESTAMP(enterAt)\x20END','holdtime','queue','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(mail_interactions.createdAt)','whatsapp_interactions.createdAt','Global\x20Count','Offered','openchannel_accounts.name','CompleteAt','agentconnectAt','UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)','dnid','1OOLCrn','13911yUtlPV','Tot\x20Unmanaged\x20Time','Neutral(%)','Type','Tot\x20Duration','UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(sms_interactions.createdAt)','Abandoned','Unmanaged\x20HoldTime','ROUND(count(id)*100/(SELECT\x20COUNT(*)\x20FROM\x20cm_hopper_history\x20WHERE\x20campaigntype=\x27queue\x27),2)','Hold\x20Time','700303CtYWsG','Avg\x20ACWTime','COUNT(IF(closed=1\x20&&\x20disposition\x20=\x27abandoned\x27,1,NULL))','ROUND(AVG(talktime))','ROUND(COUNT(IF(holdtime\x20>=30,1,NULL))\x20/\x20SUM(agentcomplete)\x20*100,1)','sms_accounts.name','answertime','TotHandleTime','chat_queues.name','BlackList','COUNT\x20(IF(voice_recordings.sentiment\x20=\x20\x27MIXED\x27,1,NULL))','COUNT\x20(IF(voice_recordings.sentiment\x20=\x20\x27POSITIVE\x27,1,NULL))'];const a1040_0x1ba3=function(_0x418983,_0x5094ac){_0x418983=_0x418983-0x19e;let _0x27f527=a1040_0x27f5[_0x418983];return _0x27f527;};const a1040_0x39660=a1040_0x1ba3;(function(_0x4fb3ef,_0x3f5abf){const _0x226958=a1040_0x1ba3;while(!![]){try{const _0x5de04d=parseInt(_0x226958(0x234))+-parseInt(_0x226958(0x270))+parseInt(_0x226958(0x25f))*-parseInt(_0x226958(0x295))+-parseInt(_0x226958(0x1eb))*parseInt(_0x226958(0x1f6))+parseInt(_0x226958(0x282))+-parseInt(_0x226958(0x1ec))*parseInt(_0x226958(0x19f))+parseInt(_0x226958(0x1c7));if(_0x5de04d===_0x3f5abf)break;else _0x4fb3ef['push'](_0x4fb3ef['shift']());}catch(_0x303d7e){_0x4fb3ef['push'](_0x4fb3ef['shift']());}}}(a1040_0x27f5,0xe11a3));const _=require(a1040_0x39660(0x252));module[a1040_0x39660(0x29b)]=function(){const _0x52b52d=a1040_0x39660,_0x45a7a0=[{'field':'uniqueid','alias':_0x52b52d(0x2ca),'ReportId':0x1},{'field':_0x52b52d(0x254),'alias':'CallerIdNum','ReportId':0x1},{'field':_0x52b52d(0x2d8),'alias':_0x52b52d(0x29f),'ReportId':0x1},{'field':_0x52b52d(0x1e1),'alias':_0x52b52d(0x21c),'ReportId':0x1},{'field':_0x52b52d(0x29d),'alias':_0x52b52d(0x24e),'ReportId':0x1},{'field':'queuecallerleaveAt','alias':'QueueLeaveAt','ReportId':0x1},{'field':_0x52b52d(0x2a7),'alias':'QueueAbandon','ReportId':0x1},{'field':_0x52b52d(0x20d),'alias':'QueueAbandonAt','ReportId':0x1},{'field':_0x52b52d(0x2cf),'alias':'Complete','ReportId':0x1},{'field':_0x52b52d(0x27d),'alias':_0x52b52d(0x1e7),'ReportId':0x1},{'field':_0x52b52d(0x2be),'alias':_0x52b52d(0x21d),'ReportId':0x1},{'field':_0x52b52d(0x255),'alias':'QueueExitAt','ReportId':0x1},{'field':_0x52b52d(0x229),'alias':_0x52b52d(0x27b),'ReportId':0x1},{'field':_0x52b52d(0x1d8),'alias':_0x52b52d(0x238),'ReportId':0x1},{'field':_0x52b52d(0x2b0),'alias':'TalkTime','format':_0x52b52d(0x236),'custom':0x1,'ReportId':0x1},{'field':_0x52b52d(0x1e9),'alias':'AbandonTime','format':_0x52b52d(0x236),'custom':0x1,'ReportId':0x1},{'field':_0x52b52d(0x206),'alias':_0x52b52d(0x2ac),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0x1},{'field':_0x52b52d(0x254),'alias':_0x52b52d(0x210),'ReportId':0x2},{'field':_0x52b52d(0x1e1),'alias':'Queue','ReportId':0x2},{'field':_0x52b52d(0x29d),'alias':_0x52b52d(0x23f),'ReportId':0x2},{'field':'CASE\x20WHEN\x20queuecallercomplete=1\x20THEN\x20queuecallercompleteAt\x20ELSE\x20queuecallerLeaveAt\x20END','alias':'EndTime','custom':0x1,'ReportId':0x2},{'field':_0x52b52d(0x1e0),'alias':'HoldTime','format':_0x52b52d(0x236),'ReportId':0x2},{'field':_0x52b52d(0x2d6),'alias':_0x52b52d(0x22b),'custom':0x1,'ReportId':0x2},{'field':'uniqueid','alias':'UniqueId','ReportId':0x3},{'field':_0x52b52d(0x254),'alias':'CallerIdNum','ReportId':0x3},{'field':_0x52b52d(0x2d8),'alias':_0x52b52d(0x29f),'ReportId':0x3},{'field':_0x52b52d(0x1e1),'alias':_0x52b52d(0x21c),'ReportId':0x3},{'field':'membername','alias':_0x52b52d(0x261),'ReportId':0x3},{'field':'agentcalledAt','alias':_0x52b52d(0x251),'ReportId':0x3},{'field':_0x52b52d(0x1e8),'alias':_0x52b52d(0x2c1),'ReportId':0x3},{'field':_0x52b52d(0x20c),'alias':'AgentCompleteAt','ReportId':0x3},{'field':_0x52b52d(0x1e0),'alias':'AnswerTime','ReportId':0x3},{'field':_0x52b52d(0x283),'alias':_0x52b52d(0x259),'ReportId':0x3},{'field':_0x52b52d(0x1d1),'alias':_0x52b52d(0x239),'ReportId':0x3},{'field':_0x52b52d(0x2bc),'alias':_0x52b52d(0x2bd),'ReportId':0x3},{'field':'agentcomplete','alias':_0x52b52d(0x2c0),'ReportId':0x3},{'field':_0x52b52d(0x245),'alias':_0x52b52d(0x225),'ReportId':0x3},{'field':_0x52b52d(0x233),'alias':'LastEvent','ReportId':0x3},{'field':_0x52b52d(0x1d8),'alias':_0x52b52d(0x238),'ReportId':0x3},{'field':_0x52b52d(0x1c1),'alias':'Agent','groupBy':0x1,'ReportId':0x4},{'field':_0x52b52d(0x1b4),'alias':_0x52b52d(0x27e),'function':_0x52b52d(0x228),'ReportId':0x4},{'field':_0x52b52d(0x283),'alias':_0x52b52d(0x1b1),'function':_0x52b52d(0x228),'format':'SEC_TO_TIME','ReportId':0x4},{'field':_0x52b52d(0x2bc),'alias':_0x52b52d(0x1af),'function':'SUM','format':'SEC_TO_TIME','ReportId':0x4},{'field':_0x52b52d(0x22a),'alias':_0x52b52d(0x1fd),'function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0x4},{'field':_0x52b52d(0x1f9),'alias':_0x52b52d(0x1a8),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0x4},{'field':_0x52b52d(0x2cc),'alias':'AvgACWTime','format':_0x52b52d(0x236),'custom':0x1,'ReportId':0x4},{'field':'ROUND(SUM(talktime\x20+\x20acwtime)/COUNT(agentcomplete))','alias':_0x52b52d(0x1ce),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0x4},{'field':_0x52b52d(0x1e1),'alias':'Queue','groupBy':0x1,'ReportId':0x5},{'field':_0x52b52d(0x1b4),'alias':_0x52b52d(0x27e),'function':_0x52b52d(0x228),'ReportId':0x5},{'field':_0x52b52d(0x283),'alias':'Tot\x20TalkTime','function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'ReportId':0x5},{'field':_0x52b52d(0x1e0),'alias':_0x52b52d(0x20a),'function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'ReportId':0x5},{'field':_0x52b52d(0x2bc),'alias':'Tot\x20ACWTime','function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'ReportId':0x5},{'field':'talktime\x20+\x20acwtime','alias':'Tot\x20Handle\x20Time','function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0x5},{'field':'ROUND(AVG(talktime))','alias':_0x52b52d(0x1a1),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0x5},{'field':_0x52b52d(0x264),'alias':_0x52b52d(0x240),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0x5},{'field':_0x52b52d(0x2cc),'alias':_0x52b52d(0x1f7),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0x5},{'field':'ROUND(SUM(talktime\x20+\x20acwtime)/COUNT(agentcomplete))','alias':_0x52b52d(0x1ca),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0x5},{'field':_0x52b52d(0x1e1),'alias':_0x52b52d(0x21c),'groupBy':0x1,'ReportId':0x6},{'field':'agentcomplete','alias':_0x52b52d(0x232),'function':'SUM','ReportId':0x6},{'field':_0x52b52d(0x2af),'alias':'Answered\x20<10s','custom':0x1,'ReportId':0x6},{'field':_0x52b52d(0x24f),'alias':_0x52b52d(0x21e),'custom':0x1,'ReportId':0x6},{'field':'COUNT(IF(holdtime\x20>=10\x20AND\x20holdtime\x20<20,1,NULL))','alias':_0x52b52d(0x297),'custom':0x1,'ReportId':0x6},{'field':'ROUND(COUNT(IF(holdtime\x20>=10\x20AND\x20holdtime\x20<20,1,NULL))\x20/\x20SUM(agentcomplete)\x20*100,1)','alias':_0x52b52d(0x1ac),'custom':0x1,'ReportId':0x6},{'field':_0x52b52d(0x1ba),'alias':_0x52b52d(0x2dc),'custom':0x1,'ReportId':0x6},{'field':_0x52b52d(0x1c9),'alias':_0x52b52d(0x2c6),'custom':0x1,'ReportId':0x6},{'field':'COUNT(IF(holdtime\x20>=30,1,NULL))','alias':_0x52b52d(0x2b6),'custom':0x1,'ReportId':0x6},{'field':_0x52b52d(0x1fa),'alias':_0x52b52d(0x230),'custom':0x1,'ReportId':0x6},{'field':'reason','alias':_0x52b52d(0x220),'groupBy':0x1,'ReportId':0x7},{'field':'uniqueid','alias':_0x52b52d(0x223),'function':'COUNT','ReportId':0x7},{'field':_0x52b52d(0x1e8),'alias':_0x52b52d(0x271),'format':_0x52b52d(0x26b),'groupBy':0x1,'ReportId':0x8},{'field':_0x52b52d(0x1b4),'alias':'Tot\x20Answered','function':_0x52b52d(0x228),'ReportId':0x8},{'field':'COUNT(IF(holdtime<10,1,NULL))','alias':_0x52b52d(0x214),'custom':0x1,'ReportId':0x8},{'field':_0x52b52d(0x29e),'alias':_0x52b52d(0x297),'custom':0x1,'ReportId':0x8},{'field':'COUNT(IF(holdtime\x20>=20\x20AND\x20holdtime\x20<30,1,NULL))','alias':_0x52b52d(0x2dc),'custom':0x1,'ReportId':0x8},{'field':_0x52b52d(0x2a8),'alias':'Answered\x20>30s','custom':0x1,'ReportId':0x8},{'field':_0x52b52d(0x2a9),'alias':_0x52b52d(0x2ca),'ReportId':0x9},{'field':'calleridnum','alias':_0x52b52d(0x287),'ReportId':0x9},{'field':_0x52b52d(0x1e1),'alias':_0x52b52d(0x21c),'ReportId':0x9},{'field':'queuecallerjoinAt','alias':_0x52b52d(0x215),'ReportId':0x9},{'field':'queuecallerleaveAt','alias':_0x52b52d(0x280),'ReportId':0x9},{'field':_0x52b52d(0x2a7),'alias':'Abandon','ReportId':0x9},{'field':_0x52b52d(0x20d),'alias':_0x52b52d(0x218),'ReportId':0x9},{'field':_0x52b52d(0x2be),'alias':'Unmanaged','ReportId':0x9},{'field':_0x52b52d(0x255),'alias':_0x52b52d(0x2ab),'ReportId':0x9},{'field':'queuecallerexitreason','alias':'UnmanagedReason','ReportId':0x9},{'field':_0x52b52d(0x1bc),'alias':'QueuePosition','ReportId':0x9},{'field':_0x52b52d(0x1d8),'alias':_0x52b52d(0x238),'ReportId':0x9},{'field':'UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)','alias':_0x52b52d(0x1a0),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0x9},{'field':_0x52b52d(0x1c8),'alias':_0x52b52d(0x1f3),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0x9},{'field':_0x52b52d(0x1e1),'alias':_0x52b52d(0x21c),'groupBy':0x1,'ReportId':0xa},{'field':_0x52b52d(0x2a7),'alias':_0x52b52d(0x1f2),'function':'SUM','ReportId':0xa},{'field':_0x52b52d(0x2be),'alias':_0x52b52d(0x2c5),'function':_0x52b52d(0x228),'ReportId':0xa},{'field':'UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)','alias':_0x52b52d(0x2d4),'function':'SUM','format':_0x52b52d(0x236),'custom':0x1,'ReportId':0xa},{'field':_0x52b52d(0x203),'alias':_0x52b52d(0x247),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0xa},{'field':_0x52b52d(0x1c8),'alias':_0x52b52d(0x1ed),'function':_0x52b52d(0x228),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0xa},{'field':_0x52b52d(0x27f),'alias':_0x52b52d(0x2d7),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0xa},{'field':_0x52b52d(0x229),'alias':'Reason','groupBy':0x1,'ReportId':0xb},{'field':_0x52b52d(0x2be),'alias':_0x52b52d(0x223),'function':_0x52b52d(0x228),'ReportId':0xb},{'field':_0x52b52d(0x1c8),'alias':'Tot\x20Unmanaged\x20Time','function':_0x52b52d(0x228),'custom':0x1,'ReportId':0xb},{'field':_0x52b52d(0x1e1),'alias':_0x52b52d(0x21c),'groupBy':0x1,'ReportId':0xc},{'field':'queuecallerabandon','alias':_0x52b52d(0x235),'function':_0x52b52d(0x228),'ReportId':0xc},{'field':'COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20<10,1,NULL))','alias':'Abandoned<10s','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':'COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20>=10\x20AND\x20UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20<60,1,NULL))','alias':'Abandoned\x2010-60s','custom':0x1,'ReportId':0xc},{'field':_0x52b52d(0x2d0),'alias':_0x52b52d(0x241),'custom':0x1,'ReportId':0xc},{'field':_0x52b52d(0x1c6),'alias':_0x52b52d(0x2a5),'custom':0x1,'ReportId':0xc},{'field':'ROUND(COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20>=60\x20AND\x20UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20<120,1,NULL))\x20\x20\x20/\x20SUM(queuecallerabandon)\x20*100,1)','alias':_0x52b52d(0x1aa),'custom':0x1,'ReportId':0xc},{'field':_0x52b52d(0x212),'alias':'Abandoned>120s','custom':0x1,'ReportId':0xc},{'field':'ROUND(COUNT(IF(UNIX_TIMESTAMP(queuecallerAbandonAt)-UNIX_TIMESTAMP(queuecallerjoinAt)\x20>=120,1,NULL))\x20\x20/\x20SUM(queuecallerabandon)\x20*100,1)','alias':_0x52b52d(0x269),'custom':0x1,'ReportId':0xc},{'field':_0x52b52d(0x1be),'alias':'Date','format':_0x52b52d(0x1d5),'groupBy':0x1,'custom':0x1,'ReportId':0xd},{'field':'uniqueid','alias':'Offered','function':_0x52b52d(0x1c3),'ReportId':0xd},{'field':_0x52b52d(0x2cf),'alias':_0x52b52d(0x27e),'function':_0x52b52d(0x228),'ReportId':0xd},{'field':'queuecallerabandon','alias':_0x52b52d(0x1f2),'function':_0x52b52d(0x228),'custom':0x1,'ReportId':0xd},{'field':'queuecallerexit','alias':_0x52b52d(0x2c5),'function':_0x52b52d(0x228),'custom':0x1,'ReportId':0xd},{'field':_0x52b52d(0x2b0),'alias':_0x52b52d(0x226),'function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0xd},{'field':_0x52b52d(0x2bb),'alias':'AvgTalkTime','format':'SEC_TO_TIME','custom':0x1,'ReportId':0xd},{'field':_0x52b52d(0x203),'alias':'AvgAbandonTime','format':_0x52b52d(0x236),'custom':0x1,'ReportId':0xd},{'field':'queuecallerjoinat','alias':_0x52b52d(0x271),'format':_0x52b52d(0x26b),'groupBy':0x1,'custom':0x1,'ReportId':0xe},{'field':_0x52b52d(0x2a9),'alias':_0x52b52d(0x1e5),'function':_0x52b52d(0x1c3),'ReportId':0xe},{'field':_0x52b52d(0x2cf),'alias':'Answered','function':_0x52b52d(0x228),'ReportId':0xe},{'field':_0x52b52d(0x1b5),'alias':_0x52b52d(0x2c7),'custom':0x1,'ReportId':0xe},{'field':_0x52b52d(0x2a7),'alias':_0x52b52d(0x1f2),'function':_0x52b52d(0x228),'ReportId':0xe},{'field':_0x52b52d(0x2be),'alias':'Unmanaged','function':_0x52b52d(0x228),'ReportId':0xe},{'field':_0x52b52d(0x2b0),'alias':_0x52b52d(0x226),'function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0xe},{'field':'ROUND(AVG(UNIX_TIMESTAMP(queuecallercompleteAt)-UNIX_TIMESTAMP(queuecallerleaveAt)))','alias':_0x52b52d(0x1a8),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0xe},{'field':_0x52b52d(0x203),'alias':_0x52b52d(0x247),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0xe},{'field':_0x52b52d(0x2c3),'alias':'Day','groupBy':0x1,'custom':0x1,'ReportId':0xf},{'field':_0x52b52d(0x2a9),'alias':'Offered','function':_0x52b52d(0x1c3),'ReportId':0xf},{'field':_0x52b52d(0x2cf),'alias':_0x52b52d(0x22b),'function':_0x52b52d(0x228),'ReportId':0xf},{'field':_0x52b52d(0x1b5),'alias':_0x52b52d(0x2c7),'custom':0x1,'ReportId':0xf},{'field':_0x52b52d(0x2a7),'alias':'Abandoned','function':_0x52b52d(0x228),'ReportId':0xf},{'field':_0x52b52d(0x2be),'alias':_0x52b52d(0x2c5),'function':'SUM','ReportId':0xf},{'field':_0x52b52d(0x2b0),'alias':_0x52b52d(0x226),'function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0xf},{'field':'ROUND(AVG(UNIX_TIMESTAMP(queuecallercompleteAt)-UNIX_TIMESTAMP(queuecallerleaveAt)))','alias':_0x52b52d(0x1a8),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0xf},{'field':_0x52b52d(0x203),'alias':_0x52b52d(0x247),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0xf},{'field':_0x52b52d(0x258),'alias':_0x52b52d(0x242),'groupBy':0x1,'custom':0x1,'ReportId':0x10},{'field':'uniqueid','alias':'Offered','function':_0x52b52d(0x1c3),'ReportId':0x10},{'field':_0x52b52d(0x2cf),'alias':_0x52b52d(0x22b),'function':_0x52b52d(0x228),'ReportId':0x10},{'field':_0x52b52d(0x1b5),'alias':'Answer\x20Rate','custom':0x1,'ReportId':0x10},{'field':_0x52b52d(0x2a7),'alias':_0x52b52d(0x1f2),'function':'SUM','orderBy':_0x52b52d(0x29a),'ReportId':0x10},{'field':_0x52b52d(0x2be),'alias':_0x52b52d(0x2c5),'function':'SUM','ReportId':0x10},{'field':'UNIX_TIMESTAMP(queuecallercompleteAt)-UNIX_TIMESTAMP(queuecallerleaveAt)','alias':_0x52b52d(0x226),'function':_0x52b52d(0x228),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0x10},{'field':_0x52b52d(0x2bb),'alias':_0x52b52d(0x1a8),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0x10},{'field':_0x52b52d(0x203),'alias':_0x52b52d(0x247),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0x10},{'field':_0x52b52d(0x1e1),'alias':_0x52b52d(0x21c),'groupBy':0x1,'ReportId':0x11},{'field':_0x52b52d(0x2a9),'alias':'Offered','function':'COUNT\x20DISTINCT','ReportId':0x11},{'field':_0x52b52d(0x2cf),'alias':_0x52b52d(0x22b),'function':_0x52b52d(0x228),'ReportId':0x11},{'field':'ROUND(SUM(queuecallercomplete)/COUNT(DISTINCT\x20uniqueid)*100,1)','alias':'Answer\x20Rate','custom':0x1,'ReportId':0x11},{'field':'queuecallerabandon','alias':_0x52b52d(0x1f2),'function':_0x52b52d(0x228),'ReportId':0x11},{'field':_0x52b52d(0x2be),'alias':'Unmanaged','function':_0x52b52d(0x228),'ReportId':0x11},{'field':_0x52b52d(0x2b0),'alias':'Tot\x20TalkTime','function':'SUM','format':'SEC_TO_TIME','custom':0x1,'ReportId':0x11},{'field':_0x52b52d(0x2bb),'alias':_0x52b52d(0x1a8),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0x11},{'field':_0x52b52d(0x203),'alias':_0x52b52d(0x247),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0x11},{'field':_0x52b52d(0x2a9),'alias':_0x52b52d(0x1b8),'ReportId':0x12},{'field':_0x52b52d(0x281),'alias':_0x52b52d(0x1ef),'ReportId':0x12},{'field':_0x52b52d(0x290),'alias':_0x52b52d(0x1c5),'ReportId':0x12},{'field':_0x52b52d(0x1de),'alias':_0x52b52d(0x207),'ReportId':0x12},{'field':_0x52b52d(0x286),'alias':'Destination','ReportId':0x12},{'field':_0x52b52d(0x26e),'alias':_0x52b52d(0x210),'ReportId':0x12},{'field':_0x52b52d(0x256),'alias':_0x52b52d(0x1da),'ReportId':0x12},{'field':_0x52b52d(0x26f),'alias':_0x52b52d(0x299),'ReportId':0x12},{'field':_0x52b52d(0x22d),'alias':_0x52b52d(0x1dd),'ReportId':0x12},{'field':'starttime','alias':_0x52b52d(0x23f),'ReportId':0x12},{'field':_0x52b52d(0x1fc),'alias':_0x52b52d(0x2ac),'ReportId':0x12},{'field':_0x52b52d(0x1c0),'alias':_0x52b52d(0x28d),'ReportId':0x12},{'field':_0x52b52d(0x278),'alias':_0x52b52d(0x21f),'ReportId':0x12},{'field':'disposition','alias':_0x52b52d(0x211),'ReportId':0x12},{'field':_0x52b52d(0x2a9),'alias':_0x52b52d(0x1b8),'ReportId':0x13},{'field':_0x52b52d(0x227),'alias':_0x52b52d(0x2a6),'ReportId':0x13},{'field':'source','alias':_0x52b52d(0x207),'ReportId':0x13},{'field':_0x52b52d(0x286),'alias':_0x52b52d(0x23a),'ReportId':0x13},{'field':_0x52b52d(0x26e),'alias':_0x52b52d(0x28f),'ReportId':0x13},{'field':_0x52b52d(0x284),'alias':_0x52b52d(0x23f),'ReportId':0x13},{'field':'answertime','alias':'AnswerTime','ReportId':0x13},{'field':_0x52b52d(0x1c0),'alias':_0x52b52d(0x28d),'ReportId':0x13},{'field':_0x52b52d(0x278),'alias':'Duration','format':'SEC_TO_TIME','ReportId':0x13},{'field':_0x52b52d(0x1a3),'alias':'Billsec','format':_0x52b52d(0x236),'ReportId':0x13},{'field':'disposition','alias':'Disposition','ReportId':0x13},{'field':'tag','alias':_0x52b52d(0x1c5),'ReportId':0x13},{'field':_0x52b52d(0x281),'alias':'Type','groupBy':0x1,'ReportId':0x14},{'field':'uniqueid','alias':'Calls','function':_0x52b52d(0x1ab),'ReportId':0x14},{'field':_0x52b52d(0x278),'alias':_0x52b52d(0x1f0),'function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'ReportId':0x14},{'field':_0x52b52d(0x1d3),'alias':_0x52b52d(0x1d6),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0x14},{'field':'disposition','alias':'Disposition','groupBy':0x1,'ReportId':0x15},{'field':_0x52b52d(0x2a9),'alias':_0x52b52d(0x223),'function':_0x52b52d(0x1ab),'ReportId':0x15},{'field':_0x52b52d(0x278),'alias':'Tot\x20Duration','function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'ReportId':0x15},{'field':_0x52b52d(0x1d3),'alias':'Avg\x20Duration','format':_0x52b52d(0x236),'custom':0x1,'ReportId':0x15},{'field':_0x52b52d(0x2a2),'alias':_0x52b52d(0x261),'groupBy':0x1,'custom':0x1,'ReportId':0x16},{'field':'uniqueid','alias':_0x52b52d(0x223),'function':'COUNT','ReportId':0x16},{'field':'duration','alias':_0x52b52d(0x1f0),'function':'SUM','format':_0x52b52d(0x236),'ReportId':0x16},{'field':_0x52b52d(0x1d3),'alias':'Avg\x20Duration','format':'SEC_TO_TIME','custom':0x1,'ReportId':0x16},{'field':_0x52b52d(0x284),'alias':_0x52b52d(0x1ae),'format':'DATE','groupBy':0x1,'ReportId':0x17},{'field':'uniqueid','alias':_0x52b52d(0x223),'function':_0x52b52d(0x1ab),'ReportId':0x17},{'field':_0x52b52d(0x278),'alias':'Tot\x20Duration','function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'ReportId':0x17},{'field':_0x52b52d(0x1d3),'alias':_0x52b52d(0x1d6),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0x17},{'field':_0x52b52d(0x1c1),'alias':_0x52b52d(0x261),'groupBy':0x1,'orderBy':_0x52b52d(0x29a),'ReportId':0x18},{'field':_0x52b52d(0x1b9),'alias':_0x52b52d(0x21f),'function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0x18},{'field':_0x52b52d(0x1c1),'alias':_0x52b52d(0x261),'groupBy':0x1,'ReportId':0x19},{'field':'CASE\x20WHEN\x20type=\x27LOGIN\x27\x20THEN\x20UNIX_TIMESTAMP(exitAt)-UNIX_TIMESTAMP(enterAt)\x20END','alias':'Login\x20Time','function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0x19},{'field':_0x52b52d(0x1df),'alias':'Talk\x20Time','function':_0x52b52d(0x228),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0x19},{'field':_0x52b52d(0x1a4),'alias':_0x52b52d(0x2cd),'function':'SUM','format':_0x52b52d(0x236),'custom':0x1,'ReportId':0x19},{'field':'membername','alias':_0x52b52d(0x261),'ReportId':0x1a},{'field':_0x52b52d(0x213),'alias':_0x52b52d(0x2a1),'ReportId':0x1a},{'field':_0x52b52d(0x209),'alias':_0x52b52d(0x1bd),'ReportId':0x1a},{'field':_0x52b52d(0x25b),'alias':_0x52b52d(0x2b7),'ReportId':0x1a},{'field':_0x52b52d(0x278),'alias':_0x52b52d(0x21f),'format':_0x52b52d(0x236),'ReportId':0x1a},{'field':_0x52b52d(0x1c1),'alias':_0x52b52d(0x261),'ReportId':0x1b},{'field':_0x52b52d(0x266),'alias':_0x52b52d(0x204),'ReportId':0x1b},{'field':_0x52b52d(0x281),'alias':_0x52b52d(0x2b9),'ReportId':0x1b},{'field':'data1','alias':_0x52b52d(0x1ef),'ReportId':0x1b},{'field':_0x52b52d(0x213),'alias':'EnterAt','ReportId':0x1b},{'field':_0x52b52d(0x209),'alias':_0x52b52d(0x1bd),'ReportId':0x1b},{'field':'UNIX_TIMESTAMP(exitAt)-UNIX_TIMESTAMP(enterAt)','alias':_0x52b52d(0x21f),'format':'SEC_TO_TIME','custom':0x1,'ReportId':0x1b},{'field':_0x52b52d(0x1c1),'alias':_0x52b52d(0x261),'groupBy':0x1,'orderBy':_0x52b52d(0x29a),'ReportId':0x1c},{'field':_0x52b52d(0x25b),'alias':_0x52b52d(0x250),'groupBy':0x1,'orderBy':'ASC','ReportId':0x1c},{'field':_0x52b52d(0x1b9),'alias':_0x52b52d(0x21f),'function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':0x1,'ReportId':0x1c},{'field':_0x52b52d(0x26a),'alias':_0x52b52d(0x1a5),'ReportId':0x1d},{'field':'uniqueid','alias':_0x52b52d(0x2ca),'ReportId':0x1d},{'field':_0x52b52d(0x26e),'alias':_0x52b52d(0x28f),'ReportId':0x1d},{'field':_0x52b52d(0x1ea),'alias':'DID','ReportId':0x1d},{'field':_0x52b52d(0x260),'alias':_0x52b52d(0x2a4),'orderBy':_0x52b52d(0x29a),'ReportId':0x1d},{'field':_0x52b52d(0x279),'alias':_0x52b52d(0x2d2),'ReportId':0x1d},{'field':_0x52b52d(0x1b3),'alias':'Duration','format':_0x52b52d(0x236),'custom':0x1,'ReportId':0x1d},{'field':_0x52b52d(0x2a9),'alias':_0x52b52d(0x25c),'ReportId':0x1e},{'field':_0x52b52d(0x26a),'alias':_0x52b52d(0x1a5),'ReportId':0x1e},{'field':_0x52b52d(0x26e),'alias':_0x52b52d(0x249),'ReportId':0x1e},{'field':'node','alias':_0x52b52d(0x1cb),'ReportId':0x1e},{'field':_0x52b52d(0x267),'alias':'Data','ReportId':0x1e},{'field':_0x52b52d(0x2ba),'alias':_0x52b52d(0x261),'groupBy':0x1,'ReportId':0x1f},{'field':'uniqueid','alias':_0x52b52d(0x1cf),'function':_0x52b52d(0x1ab),'ReportId':0x1f},{'field':'rating','alias':'Total\x20Rating','function':'SUM','ReportId':0x1f},{'field':_0x52b52d(0x28b),'alias':'Avg\x20Rating','function':_0x52b52d(0x22f),'ReportId':0x1f},{'field':'queue','alias':_0x52b52d(0x21c),'groupBy':0x1,'ReportId':0x20},{'field':_0x52b52d(0x2a9),'alias':_0x52b52d(0x1a9),'function':_0x52b52d(0x1ab),'ReportId':0x20},{'field':'rating','alias':_0x52b52d(0x272),'function':_0x52b52d(0x228),'ReportId':0x20},{'field':_0x52b52d(0x28b),'alias':_0x52b52d(0x2d9),'function':'AVG','ReportId':0x20},{'field':'campaign','alias':'Campaign\x20Name','ReportId':0x21},{'field':_0x52b52d(0x254),'alias':_0x52b52d(0x287),'ReportId':0x21},{'field':_0x52b52d(0x284),'alias':_0x52b52d(0x202),'orderBy':_0x52b52d(0x298),'ReportId':0x21},{'field':_0x52b52d(0x293),'alias':_0x52b52d(0x243),'ReportId':0x21},{'field':_0x52b52d(0x244),'alias':_0x52b52d(0x1e4),'ReportId':0x21},{'field':_0x52b52d(0x274),'alias':'Drop\x20Reason','ReportId':0x21},{'field':_0x52b52d(0x27c),'alias':'BlackList','ReportId':0x21},{'field':_0x52b52d(0x1c1),'alias':_0x52b52d(0x261),'ReportId':0x21},{'field':'talktime','alias':_0x52b52d(0x2b8),'ReportId':0x21},{'field':'disposition','alias':_0x52b52d(0x211),'ReportId':0x21},{'field':_0x52b52d(0x2a9),'alias':_0x52b52d(0x2ca),'ReportId':0x21},{'field':_0x52b52d(0x293),'alias':_0x52b52d(0x243),'groupBy':!![],'orderBy':_0x52b52d(0x29a),'ReportId':0x22},{'field':'id','alias':_0x52b52d(0x223),'function':_0x52b52d(0x1ab),'ReportId':0x22},{'field':_0x52b52d(0x1f4),'alias':_0x52b52d(0x296),'custom':!![],'ReportId':0x22},{'field':_0x52b52d(0x224),'alias':_0x52b52d(0x24c),'orderBy':_0x52b52d(0x29a),'groupBy':!![],'ReportId':0x23},{'field':_0x52b52d(0x293),'alias':'State','groupBy':!![],'ReportId':0x23},{'field':'id','alias':'Total\x20Calls','function':'COUNT','ReportId':0x23},{'field':'ListId','groupBy':!![],'orderBy':'ASC','ReportId':0x24},{'field':'id','alias':_0x52b52d(0x24d),'function':_0x52b52d(0x1ab),'ReportId':0x24},{'field':_0x52b52d(0x26c),'alias':_0x52b52d(0x1c2),'custom':!![],'ReportId':0x24},{'field':_0x52b52d(0x2da),'alias':_0x52b52d(0x2b4),'custom':!![],'ReportId':0x24},{'field':_0x52b52d(0x1c1),'alias':'Agent','groupBy':!![],'orderBy':_0x52b52d(0x29a),'ReportId':0x25},{'field':'id','alias':_0x52b52d(0x223),'function':_0x52b52d(0x1ab),'ReportId':0x25},{'field':'SEC_TO_TIME(AVG(talktime))','alias':_0x52b52d(0x1a7),'custom':!![],'ReportId':0x25},{'field':_0x52b52d(0x1d9),'alias':_0x52b52d(0x211),'groupBy':!![],'ReportId':0x26},{'field':'id','alias':'Total','function':_0x52b52d(0x1ab),'ReportId':0x26},{'field':_0x52b52d(0x2c2),'alias':_0x52b52d(0x205),'custom':!![],'ReportId':0x26},{'field':_0x52b52d(0x1c1),'alias':_0x52b52d(0x261),'groupBy':!![],'ReportId':0x27},{'field':_0x52b52d(0x1d9),'alias':'Disposition','groupBy':!![],'ReportId':0x27},{'field':'id','alias':_0x52b52d(0x23c),'function':_0x52b52d(0x1ab),'ReportId':0x27},{'field':_0x52b52d(0x2c2),'alias':'Total\x20(%)','custom':!![],'ReportId':0x27},{'field':_0x52b52d(0x224),'alias':_0x52b52d(0x24c),'ReportId':0x28},{'field':'calleridnum','alias':'CallerIdNum','ReportId':0x28},{'field':'starttime','alias':_0x52b52d(0x202),'orderBy':_0x52b52d(0x298),'ReportId':0x28},{'field':'statedesc','alias':_0x52b52d(0x243),'ReportId':0x28},{'field':_0x52b52d(0x244),'alias':_0x52b52d(0x1e4),'ReportId':0x28},{'field':_0x52b52d(0x274),'alias':_0x52b52d(0x28c),'ReportId':0x28},{'field':_0x52b52d(0x27c),'alias':_0x52b52d(0x1ff),'ReportId':0x28},{'field':_0x52b52d(0x283),'alias':'Talk\x20Time','ReportId':0x28},{'field':_0x52b52d(0x2a9),'alias':'UniqueId','ReportId':0x28},{'field':_0x52b52d(0x293),'alias':_0x52b52d(0x243),'groupBy':!![],'orderBy':_0x52b52d(0x29a),'ReportId':0x29},{'field':'id','alias':'Calls','function':_0x52b52d(0x1ab),'ReportId':0x29},{'field':_0x52b52d(0x25a),'alias':_0x52b52d(0x296),'custom':!![],'ReportId':0x29},{'field':_0x52b52d(0x224),'alias':_0x52b52d(0x24c),'orderBy':_0x52b52d(0x29a),'groupBy':!![],'ReportId':0x2a},{'field':_0x52b52d(0x293),'alias':_0x52b52d(0x243),'groupBy':!![],'ReportId':0x2a},{'field':'id','alias':_0x52b52d(0x24b),'function':_0x52b52d(0x1ab),'ReportId':0x2a},{'field':_0x52b52d(0x1b7),'groupBy':!![],'orderBy':'ASC','ReportId':0x2b},{'field':'id','alias':_0x52b52d(0x24d),'function':_0x52b52d(0x1ab),'ReportId':0x2b},{'field':_0x52b52d(0x26c),'alias':_0x52b52d(0x1c2),'custom':!![],'ReportId':0x2b},{'field':'ROUND(SUM(IF(state=4,1,0))/COUNT(*)*100,1)','alias':_0x52b52d(0x2b4),'custom':!![],'ReportId':0x2b},{'field':_0x52b52d(0x292),'alias':_0x52b52d(0x1cc),'groupBy':!![],'ReportId':0x2c},{'field':_0x52b52d(0x262),'alias':_0x52b52d(0x21a),'function':_0x52b52d(0x1ab),'ReportId':0x2c},{'field':'COUNT(IF(closed=0,1,NULL))','alias':_0x52b52d(0x1dc),'custom':!![],'ReportId':0x2c},{'field':'COUNT(IF(closed=1\x20&&\x20((disposition\x20!=\x27unmanaged\x27\x20&&\x20disposition\x20!=\x27abandoned\x27)\x20||\x20disposition\x20IS\x20NULL),1,NULL))','alias':'Closed','custom':!![],'ReportId':0x2c},{'field':_0x52b52d(0x208),'alias':'Unmanaged','custom':!![],'ReportId':0x2c},{'field':_0x52b52d(0x1f8),'alias':_0x52b52d(0x1f2),'custom':!![],'ReportId':0x2c},{'field':_0x52b52d(0x292),'alias':_0x52b52d(0x1cc),'groupBy':!![],'ReportId':0x2d},{'field':_0x52b52d(0x2b1),'alias':'Interaction\x20Time','function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x2d},{'field':_0x52b52d(0x25e),'alias':_0x52b52d(0x2cb),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x2d},{'field':_0x52b52d(0x23b),'alias':_0x52b52d(0x261),'groupBy':!![],'ReportId':0x2e},{'field':_0x52b52d(0x2ad),'alias':'Closed','function':_0x52b52d(0x228),'ReportId':0x2e},{'field':_0x52b52d(0x2b1),'alias':_0x52b52d(0x288),'function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x2e},{'field':_0x52b52d(0x25e),'alias':_0x52b52d(0x2cb),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x2e},{'field':'chat_interactions.createdAt','alias':_0x52b52d(0x1ae),'format':_0x52b52d(0x1d5),'groupBy':!![],'custom':!![],'ReportId':0x2f},{'field':_0x52b52d(0x262),'alias':_0x52b52d(0x21a),'function':_0x52b52d(0x1ab),'ReportId':0x2f},{'field':_0x52b52d(0x2aa),'alias':_0x52b52d(0x27e),'custom':!![],'ReportId':0x2f},{'field':_0x52b52d(0x2d1),'alias':'Completed\x20(%)','custom':!![],'ReportId':0x2f},{'field':_0x52b52d(0x208),'alias':_0x52b52d(0x2c5),'custom':!![],'ReportId':0x2f},{'field':_0x52b52d(0x1c4),'alias':_0x52b52d(0x1d4),'custom':!![],'ReportId':0x2f},{'field':'COUNT(IF(closed=1\x20&&\x20disposition\x20=\x27abandoned\x27,1,NULL))','alias':_0x52b52d(0x1f2),'custom':!![],'ReportId':0x2f},{'field':_0x52b52d(0x1a2),'alias':'Abandoned\x20(%)','custom':!![],'ReportId':0x2f},{'field':_0x52b52d(0x20f),'alias':_0x52b52d(0x288),'function':_0x52b52d(0x228),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x2f},{'field':_0x52b52d(0x28e),'alias':_0x52b52d(0x2cb),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x2f},{'field':_0x52b52d(0x1fe),'alias':_0x52b52d(0x21c),'groupBy':!![],'ReportId':0x30},{'field':'report_chat_queue.id','alias':_0x52b52d(0x21a),'function':_0x52b52d(0x1ab),'ReportId':0x30},{'field':_0x52b52d(0x221),'alias':'Accepted','custom':!![],'ReportId':0x30},{'field':_0x52b52d(0x263),'alias':_0x52b52d(0x1bf),'custom':!![],'ReportId':0x30},{'field':'UNIX_TIMESTAMP(leaveAt)-UNIX_TIMESTAMP(joinAt)','alias':_0x52b52d(0x1f5),'function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x30},{'field':'ROUND(AVG(UNIX_TIMESTAMP(leaveAt)-UNIX_TIMESTAMP(joinAt)))','alias':_0x52b52d(0x246),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x30},{'field':_0x52b52d(0x1db),'alias':'Email\x20Account','groupBy':!![],'ReportId':0x31},{'field':'mail_interactions.id','alias':_0x52b52d(0x21a),'function':_0x52b52d(0x1ab),'ReportId':0x31},{'field':_0x52b52d(0x222),'alias':_0x52b52d(0x1dc),'custom':!![],'ReportId':0x31},{'field':_0x52b52d(0x291),'alias':_0x52b52d(0x1b2),'custom':!![],'ReportId':0x31},{'field':_0x52b52d(0x1db),'alias':_0x52b52d(0x289),'groupBy':!![],'ReportId':0x32},{'field':_0x52b52d(0x1e2),'alias':_0x52b52d(0x288),'function':'SUM','format':_0x52b52d(0x236),'custom':!![],'ReportId':0x32},{'field':'ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(mail_interactions.createdAt)))','alias':_0x52b52d(0x2cb),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x32},{'field':'users.fullname','alias':_0x52b52d(0x261),'groupBy':!![],'ReportId':0x33},{'field':_0x52b52d(0x2b2),'alias':_0x52b52d(0x1b2),'function':_0x52b52d(0x228),'ReportId':0x33},{'field':_0x52b52d(0x1e2),'alias':'Interaction\x20Time','function':'SUM','format':_0x52b52d(0x236),'custom':!![],'ReportId':0x33},{'field':_0x52b52d(0x28a),'alias':_0x52b52d(0x2cb),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x33},{'field':_0x52b52d(0x1b6),'alias':'Date','format':'DATE','groupBy':!![],'custom':!![],'ReportId':0x34},{'field':_0x52b52d(0x1bb),'alias':_0x52b52d(0x21a),'function':'COUNT','ReportId':0x34},{'field':_0x52b52d(0x291),'alias':_0x52b52d(0x27e),'custom':!![],'ReportId':0x34},{'field':'ROUND(COUNT(IF(closed=1,1,NULL))/COUNT(id)\x20*100,1)','alias':_0x52b52d(0x25d),'custom':!![],'ReportId':0x34},{'field':_0x52b52d(0x20f),'alias':'Interaction\x20Time','function':_0x52b52d(0x228),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x34},{'field':_0x52b52d(0x28e),'alias':_0x52b52d(0x2cb),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x34},{'field':_0x52b52d(0x2b3),'alias':_0x52b52d(0x21c),'groupBy':!![],'ReportId':0x35},{'field':_0x52b52d(0x219),'alias':'Interactions','function':_0x52b52d(0x1ab),'ReportId':0x35},{'field':'COUNT(IF(reason=\x27accepted\x27,1,NULL))','alias':'Accepted','custom':!![],'ReportId':0x35},{'field':'COUNT(IF(reason=\x27timeout\x27,1,NULL))','alias':_0x52b52d(0x1bf),'custom':!![],'ReportId':0x35},{'field':_0x52b52d(0x1b3),'alias':_0x52b52d(0x1f5),'function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x35},{'field':_0x52b52d(0x19e),'alias':_0x52b52d(0x246),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x35},{'field':_0x52b52d(0x1e6),'alias':_0x52b52d(0x248),'groupBy':!![],'ReportId':0x36},{'field':'openchannel_interactions.id','alias':_0x52b52d(0x21a),'function':'COUNT','ReportId':0x36},{'field':'COUNT(IF(closed=0,1,NULL))','alias':_0x52b52d(0x1dc),'custom':!![],'ReportId':0x36},{'field':_0x52b52d(0x291),'alias':'Closed','custom':!![],'ReportId':0x36},{'field':'openchannel_accounts.name','alias':_0x52b52d(0x248),'groupBy':!![],'ReportId':0x37},{'field':_0x52b52d(0x216),'alias':_0x52b52d(0x288),'function':_0x52b52d(0x228),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x37},{'field':_0x52b52d(0x1cd),'alias':'AVG\x20Interaction\x20Time','format':_0x52b52d(0x236),'custom':!![],'ReportId':0x37},{'field':_0x52b52d(0x23b),'alias':_0x52b52d(0x261),'groupBy':!![],'ReportId':0x38},{'field':_0x52b52d(0x1d7),'alias':'Closed','function':_0x52b52d(0x228),'ReportId':0x38},{'field':_0x52b52d(0x216),'alias':'Interaction\x20Time','function':_0x52b52d(0x228),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x38},{'field':_0x52b52d(0x1cd),'alias':'AVG\x20Interaction\x20Time','format':_0x52b52d(0x236),'custom':!![],'ReportId':0x38},{'field':_0x52b52d(0x1a6),'alias':_0x52b52d(0x1ae),'format':_0x52b52d(0x1d5),'groupBy':!![],'custom':!![],'ReportId':0x39},{'field':_0x52b52d(0x23d),'alias':_0x52b52d(0x21a),'function':_0x52b52d(0x1ab),'ReportId':0x39},{'field':'COUNT(IF(closed=1,1,NULL))','alias':_0x52b52d(0x27e),'custom':!![],'ReportId':0x39},{'field':_0x52b52d(0x29c),'alias':_0x52b52d(0x25d),'custom':!![],'ReportId':0x39},{'field':_0x52b52d(0x20f),'alias':_0x52b52d(0x288),'function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x39},{'field':'ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)))','alias':'AVG\x20Interaction\x20Time','format':'SEC_TO_TIME','custom':!![],'ReportId':0x39},{'field':'openchannel_queues.name','alias':_0x52b52d(0x21c),'groupBy':!![],'ReportId':0x3a},{'field':'report_openchannel_queue.id','alias':_0x52b52d(0x21a),'function':'COUNT','ReportId':0x3a},{'field':_0x52b52d(0x221),'alias':_0x52b52d(0x2c4),'custom':!![],'ReportId':0x3a},{'field':'COUNT(IF(reason=\x27timeout\x27,1,NULL))','alias':'Timeout','custom':!![],'ReportId':0x3a},{'field':_0x52b52d(0x1b3),'alias':'Hold\x20Time','function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x3a},{'field':_0x52b52d(0x19e),'alias':_0x52b52d(0x246),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x3a},{'field':_0x52b52d(0x1fb),'alias':_0x52b52d(0x277),'groupBy':!![],'ReportId':0x3b},{'field':_0x52b52d(0x1ad),'alias':'Interactions','function':_0x52b52d(0x1ab),'ReportId':0x3b},{'field':_0x52b52d(0x222),'alias':_0x52b52d(0x1dc),'custom':!![],'ReportId':0x3b},{'field':'COUNT(IF(closed=1,1,NULL))','alias':_0x52b52d(0x1b2),'custom':!![],'ReportId':0x3b},{'field':_0x52b52d(0x1fb),'alias':'Sms\x20Account','groupBy':!![],'ReportId':0x3c},{'field':_0x52b52d(0x1f1),'alias':_0x52b52d(0x288),'function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x3c},{'field':_0x52b52d(0x2bf),'alias':_0x52b52d(0x2cb),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x3c},{'field':'users.fullname','alias':_0x52b52d(0x261),'groupBy':!![],'ReportId':0x3d},{'field':_0x52b52d(0x253),'alias':'Closed','function':_0x52b52d(0x228),'ReportId':0x3d},{'field':_0x52b52d(0x1f1),'alias':'Interaction\x20Time','function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x3d},{'field':_0x52b52d(0x2bf),'alias':_0x52b52d(0x2cb),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x3d},{'field':_0x52b52d(0x20e),'alias':'Date','format':_0x52b52d(0x1d5),'groupBy':!![],'custom':!![],'ReportId':0x3e},{'field':'sms_interactions.id','alias':_0x52b52d(0x21a),'function':_0x52b52d(0x1ab),'ReportId':0x3e},{'field':_0x52b52d(0x291),'alias':_0x52b52d(0x27e),'custom':!![],'ReportId':0x3e},{'field':_0x52b52d(0x29c),'alias':_0x52b52d(0x25d),'custom':!![],'ReportId':0x3e},{'field':'UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)','alias':'Interaction\x20Time','function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x3e},{'field':_0x52b52d(0x28e),'alias':_0x52b52d(0x2cb),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x3e},{'field':'sms_queues.name','alias':_0x52b52d(0x21c),'groupBy':!![],'ReportId':0x3f},{'field':'report_sms_queue.id','alias':_0x52b52d(0x21a),'function':_0x52b52d(0x1ab),'ReportId':0x3f},{'field':_0x52b52d(0x221),'alias':_0x52b52d(0x2c4),'custom':!![],'ReportId':0x3f},{'field':_0x52b52d(0x263),'alias':_0x52b52d(0x1bf),'custom':!![],'ReportId':0x3f},{'field':_0x52b52d(0x1b3),'alias':_0x52b52d(0x1f5),'function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x3f},{'field':_0x52b52d(0x19e),'alias':_0x52b52d(0x246),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x3f},{'field':_0x52b52d(0x2d3),'alias':'Queue','groupBy':!![],'ReportId':0x44},{'field':'report_fax_queue.id','alias':_0x52b52d(0x21a),'function':_0x52b52d(0x1ab),'ReportId':0x44},{'field':_0x52b52d(0x221),'alias':'Accepted','custom':!![],'ReportId':0x44},{'field':'COUNT(IF(reason=\x27timeout\x27,1,NULL))','alias':_0x52b52d(0x1bf),'custom':!![],'ReportId':0x44},{'field':_0x52b52d(0x1b3),'alias':_0x52b52d(0x1f5),'function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x44},{'field':_0x52b52d(0x19e),'alias':_0x52b52d(0x246),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x44},{'field':_0x52b52d(0x22e),'alias':_0x52b52d(0x1ae),'format':'DATE','groupBy':!![],'custom':!![],'ReportId':0x43},{'field':_0x52b52d(0x1d0),'alias':'Interactions','function':_0x52b52d(0x1ab),'ReportId':0x43},{'field':_0x52b52d(0x291),'alias':_0x52b52d(0x27e),'custom':!![],'ReportId':0x43},{'field':'ROUND(COUNT(IF(closed=1,1,NULL))/COUNT(id)\x20*100,1)','alias':'Completed\x20(%)','custom':!![],'ReportId':0x43},{'field':'UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)','alias':'Interaction\x20Time','function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x43},{'field':_0x52b52d(0x28e),'alias':_0x52b52d(0x2cb),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x43},{'field':_0x52b52d(0x23b),'alias':_0x52b52d(0x261),'groupBy':!![],'ReportId':0x42},{'field':_0x52b52d(0x237),'alias':_0x52b52d(0x1b2),'function':_0x52b52d(0x228),'ReportId':0x42},{'field':_0x52b52d(0x265),'alias':_0x52b52d(0x288),'function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x42},{'field':_0x52b52d(0x1b0),'alias':_0x52b52d(0x2cb),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x42},{'field':'fax_accounts.name','alias':_0x52b52d(0x24a),'groupBy':!![],'ReportId':0x41},{'field':_0x52b52d(0x265),'alias':'Interaction\x20Time','function':_0x52b52d(0x228),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x41},{'field':_0x52b52d(0x1b0),'alias':_0x52b52d(0x2cb),'format':'SEC_TO_TIME','custom':!![],'ReportId':0x41},{'field':'fax_accounts.name','alias':'Fax\x20Account','groupBy':!![],'ReportId':0x40},{'field':_0x52b52d(0x1d0),'alias':_0x52b52d(0x21a),'function':_0x52b52d(0x1ab),'ReportId':0x40},{'field':_0x52b52d(0x222),'alias':'Open','custom':!![],'ReportId':0x40},{'field':'COUNT(IF(closed=1,1,NULL))','alias':_0x52b52d(0x1b2),'custom':!![],'ReportId':0x40},{'field':_0x52b52d(0x285),'alias':_0x52b52d(0x2a3),'groupBy':!![],'custom':![],'ReportId':0x4a},{'field':_0x52b52d(0x23b),'alias':_0x52b52d(0x20b),'groupBy':![],'custom':![],'ReportId':0x4a},{'field':_0x52b52d(0x201),'alias':_0x52b52d(0x2c9),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x52b52d(0x268),'alias':_0x52b52d(0x2b5),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':'COUNT\x20(IF(voice_recordings.sentiment\x20=\x20\x27NEUTRAL\x27,1,NULL))','alias':_0x52b52d(0x2ce),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x52b52d(0x200),'alias':_0x52b52d(0x26d),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x52b52d(0x2c8),'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':_0x52b52d(0x217),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x52b52d(0x276),'alias':_0x52b52d(0x22c),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':'CONCAT(ROUND((\x20(SELECT\x20COUNT(IF(voice_recordings.sentiment\x20=\x20\x27NEUTRAL\x27,1,NULL)))*100/\x20COUNT\x20(voice_recordings.sentiment)),2),\x27%\x27)','alias':'Neutral(%)','groupBy':![],'custom':!![],'ReportId':0x4a},{'field':_0x52b52d(0x23e),'alias':_0x52b52d(0x2ae),'groupBy':![],'custom':!![],'ReportId':0x4a},{'field':'voice_recordings.sentiment','alias':_0x52b52d(0x257),'function':'COUNT','groupBy':![],'custom':![],'ReportId':0x4b},{'field':_0x52b52d(0x201),'alias':_0x52b52d(0x2c9),'groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x52b52d(0x268),'alias':'NEGATIVE','groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x52b52d(0x27a),'alias':_0x52b52d(0x2ce),'groupBy':![],'custom':!![],'ReportId':0x4b},{'field':'COUNT\x20(IF(voice_recordings.sentiment\x20=\x20\x27MIXED\x27,1,NULL))','alias':_0x52b52d(0x26d),'groupBy':![],'custom':!![],'ReportId':0x4b},{'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':_0x52b52d(0x217),'groupBy':![],'custom':!![],'ReportId':0x4b},{'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':_0x52b52d(0x22c),'groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x52b52d(0x2d5),'alias':_0x52b52d(0x1ee),'groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x52b52d(0x23e),'alias':'Mixed(%)','groupBy':![],'custom':!![],'ReportId':0x4b},{'field':_0x52b52d(0x273),'alias':_0x52b52d(0x231),'groupBy':!![],'ReportId':0x45},{'field':_0x52b52d(0x2db),'alias':_0x52b52d(0x21a),'function':_0x52b52d(0x1ab),'ReportId':0x45},{'field':_0x52b52d(0x222),'alias':_0x52b52d(0x1dc),'custom':!![],'ReportId':0x45},{'field':_0x52b52d(0x291),'alias':_0x52b52d(0x1b2),'custom':!![],'ReportId':0x45},{'field':_0x52b52d(0x273),'alias':_0x52b52d(0x231),'groupBy':!![],'ReportId':0x46},{'field':'UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(whatsapp_interactions.createdAt)','alias':_0x52b52d(0x288),'function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x46},{'field':_0x52b52d(0x21b),'alias':_0x52b52d(0x2cb),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x46},{'field':_0x52b52d(0x23b),'alias':_0x52b52d(0x261),'groupBy':!![],'ReportId':0x47},{'field':_0x52b52d(0x2a0),'alias':_0x52b52d(0x1b2),'function':'SUM','ReportId':0x47},{'field':_0x52b52d(0x1d2),'alias':_0x52b52d(0x288),'function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x47},{'field':_0x52b52d(0x21b),'alias':_0x52b52d(0x2cb),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x47},{'field':_0x52b52d(0x1e3),'alias':_0x52b52d(0x1ae),'format':_0x52b52d(0x1d5),'groupBy':!![],'custom':!![],'ReportId':0x48},{'field':_0x52b52d(0x2db),'alias':_0x52b52d(0x21a),'function':_0x52b52d(0x1ab),'ReportId':0x48},{'field':_0x52b52d(0x291),'alias':_0x52b52d(0x27e),'custom':!![],'ReportId':0x48},{'field':_0x52b52d(0x29c),'alias':_0x52b52d(0x25d),'custom':!![],'ReportId':0x48},{'field':'UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)','alias':_0x52b52d(0x288),'function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x48},{'field':'ROUND(AVG(UNIX_TIMESTAMP(closedAt)-UNIX_TIMESTAMP(createdAt)))','alias':_0x52b52d(0x2cb),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x48},{'field':_0x52b52d(0x294),'alias':'Queue','groupBy':!![],'ReportId':0x49},{'field':'report_whatsapp_queue.id','alias':_0x52b52d(0x21a),'function':'COUNT','ReportId':0x49},{'field':_0x52b52d(0x221),'alias':_0x52b52d(0x2c4),'custom':!![],'ReportId':0x49},{'field':'COUNT(IF(reason=\x27timeout\x27,1,NULL))','alias':'Timeout','custom':!![],'ReportId':0x49},{'field':'UNIX_TIMESTAMP(leaveAt)-UNIX_TIMESTAMP(joinAt)','alias':_0x52b52d(0x1f5),'function':_0x52b52d(0x228),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x49},{'field':_0x52b52d(0x19e),'alias':_0x52b52d(0x246),'format':_0x52b52d(0x236),'custom':!![],'ReportId':0x49}];return _['groupBy'](_0x45a7a0,_0x52b52d(0x275));};
\ No newline at end of file