1 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');};
git://repos.xcallymotion.com / motion-next.git / blob