This is an old revision of the document!

Tickertape SQL Queries

TEMP EWT

SELECT
SGRT.[SkillTargetID]
,SG.EnterpriseName
,DefaultAvgHandledTime = SG_AHT.avghandletime
,[RouterCallsQNow]
,[AvgHandledCallsTimeTo5]
,[Ready]
,[TalkingIn]
,[TalkingOther]
,[TalkingOut]
,[RouterLongestCallInQ]
,AgentsTalking = (TalkingIn+TalkingOut+TalkingOther)
,CASE
WHEN [Ready] > (TalkingIn+TalkingOut+TalkingOther) THEN [Ready]
ELSE (TalkingIn+TalkingOut+TalkingOther)
END AS AgentCount
 
FROM
[vhi_awdb].[dbo].[Skill_Group_Real_Time] SGRT
LEFT JOIN Skill_Group SG ON SG.SkillTargetID = SGRT.SkillTargetID	
JOIN skillgroup_avghandletime SG_AHT ON SGRT.SkillTargetID = SG_AHT.id
  • myapps/tickertape/sql.1610727141.txt.gz
  • Last modified: 2021/01/15 16:12
  • by gerardorourke