Built motion from commit bfc7a72f7045b27461c9a5d1f71c1a658cfd0b8b. Version 3.0.0...

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

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