- Created by MEENA THEEBAN on Dec 13, 2019
-
Translate page
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
Version 1 Next »
The eMite Index Server maps the document keywords from the elasticsearch data storage against a virtual multidimensional array to allow advanced analytics and reporting. This data is displayed as either a Measure or Dimension, according to its definition. Additionally, the eMite RTBI engine allows for the creation of custom Measures and Dimensions. This data dictionary includes both Predefined and Custom definitions.
More details for PureCloud metric definitions can be found here.
Predefined Measures
There are a number of predefined measures which map directly to PureCloud metrics.
Predefined Measures
| eMite Alias | Genesys Metric Name | Genesys Metric Definition | eMite Index |
|---|---|---|---|
| nError Count | nError Count | The number of active sessions aborted due to an Edge or adapter error event. | AgentHistory, QueueHistory, WrapUpCodesHistory |
| nOffered Count | nOffered Count | The number of interactions offered to a queue by an Automatic Call Distributor (ACD). | AgentHistory, QueueHistory |
| nOutboundAbandoned Count | nOutboundAbandoned Count | The number of outbound dialer calls that were abandoned. | AgentHistory, QueueHistory |
| nOutboundAttempted Count | nOutboundAttempted Count | The number of oubound calls attempted. | AgentHistory, QueueHistory |
| nOutboundConnected Count | nOutboundConnected Count | The number of outbound calls that connected. | AgentHistory, QueueHistory |
| nOverSla Count | nOverSla Count | The number of answered interactions that were over the SLA threshold. | AgentHistory, QueueHistory |
| nStateTransitionError Count | nStateTransitionError Count | The number of errors caused by Edge clock skew. | AgentHistory, QueueHistory |
| nTransferred Count | nTransferred Count | The number of interactions transferred. This includes blind and consult transfers. | AgentHistory, QueueHistory |
| tAcd Count | tAcd Count | The amount of time an Automatic Call Distributor (ACD) was involved in an interaction. | AgentHistory, QueueHistory |
| tAcd Max | tAcd Max | AgentHistory, QueueHistory | |
| tAcd Min | tAcd Min | AgentHistory, QueueHistory | |
| tAcd Time | tAcd Sum | AgentHistory, QueueHistory | |
| tAcw Count | tAcw Count | The amount of time spent in after call work. | AgentHistory, QueueHistory, WrapUpCodesHistory |
| tAcw Max | tAcw Max | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tAcw Min | tAcw Min | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tAcw Time | tAcw Sum | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tAgentResponse Count | tAgentResponseTime Count | The amount of time the user spent waiting for a response from the agent. | AgentHistory, QueueHistory |
| tAgentResponse Max | tAgentResponseTime Max | AgentHistory, QueueHistory | |
| tAgentResponse Min | tAgentResponseTime Min | AgentHistory, QueueHistory | |
| tAgentResponse Time | tAgentResponseTime Sum | AgentHistory, QueueHistory | |
| tAnswered Count | tAnswered Count | The amount of time an interaction waited to be connected to an agent. | AgentHistory, QueueHistory, WrapUpCodesHistory |
| tAnswered Max | tAnswered Max | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tAnswered Min | tAnswered Min | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tAnswered Time | tAnswered Sum | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tHandle Count | tHandle Count | The complete time an agent spent on an interaction, includes time spent contacting, time spent dialing, talk time, hold time, and after call work. | AgentHistory, QueueHistory, WrapUpCodesHistory |
| tHandle Max | tHandle Max | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tHandle Min | tHandle Min | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tHandle Time | tHandle Sum | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tHeld Count | tHeld Count | The amount of time an interaction was placed on hold. | AgentHistory, QueueHistory, WrapUpCodesHistory |
| tHeld Max | tHeld Max | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tHeld Min | tHeld Min | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tHeld Time | tHeld Sum | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tHeldComplete Count | tHeldComplete Count | The overall hold time for an interaction. | AgentHistory, QueueHistory, WrapUpCodesHistory |
| tHeldComplete Max | tHeldComplete Max | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tHeldComplete Min | tHeldComplete Min | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tHeldComplete Time | tHeldComplete Sum | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tTalk Count | tTalk Count | Time an agent spent talking/interacting. | AgentHistory, QueueHistory, WrapUpCodesHistory |
| tTalk Max | tTalk Max | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tTalk Min | tTalk Min | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tTalk Time | tTalk Sum | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tTalkComplete Count | tTalkComplete Count | The overall time an agent spent talking/interacting. | AgentHistory, QueueHistory, WrapUpCodesHistory |
| tTalkComplete Max | tTalkComplete Max | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tTalkComplete Min | tTalkComplete Min | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tTalkComplete Time | tTalkComplete Sum | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tVoicemail Count | tVoicemail Count | The amount of time spent in voicemail. | AgentHistory, QueueHistory |
| tVoicemail Max | tVoicemail Max | AgentHistory, QueueHistory | |
| tVoicemail Min | tVoicemail Min | AgentHistory, QueueHistory | |
| tVoicemail Time | tVoicemail Sum | AgentHistory, QueueHistory | |
| tWait Count | tWait Count | The amount of time a party waited; the sum of tAnswered and tAbandon. | AgentHistory, QueueHistory, WrapUpCodesHistory |
| tWait Max | tWait Max | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tWait Min | tWait Min | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tWait Time | tWait Sum | AgentHistory, QueueHistory, WrapUpCodesHistory | |
| tAgentRoutingStatus Time | tAgentRoutingStatus Sum | The amount of time an agent spent in a given routing status, such as interacting, idle, or not responding. | AgentPresence |
| tOrganizationPresence Time | tOrganizationPresence Sum | The amount of time spent in a user-defined status setting, such as "lunch at desk" or "writing emails". | AgentPresence |
| tAbandon Count | tAbandon Count | The amount of time before an end user abandoned an interaction in a queue. | QueueHistory |
| tAbandon Max | tAbandon Max | QueueHistory | |
| tAbandon Min | tAbandon Min | QueueHistory | |
| tAbandon Time | tAbandon Sum | QueueHistory | |
| tIvr Count | tIvr Count | The amount of time spent in IVR. | QueueHistory |
| tIvr Max | tIvr Max | QueueHistory | |
| tIvr Min | tIvr Min | QueueHistory | |
| tIvr Time | tIvr Sum | QueueHistory | |
| tUserResponse Count | tUserResponseTime Count | The amount of time spent waiting for an end user response. | QueueHistory |
| tUserResponse Max | tUserResponseTime Max | QueueHistory | |
| tUserResponse Min | tUserResponseTime Min | QueueHistory | |
| tUserResponse Sum | tUserResponseTime Sum | QueueHistory | |
| tLongAbandon Count | tLongAbandon Count | QueueHistory | |
| tLongAbandon Max | tLongAbandon Max | QueueHistory | |
| tLongAbandon Min | tLongAbandon Min | QueueHistory | |
| tLongAbandon Time | tLongAbandon Time | QueueHistory | |
| tShortAbandon Count | tShortAbandon Count | QueueHistory | |
| tShortAbandon Max | tShortAbandon Max | QueueHistory | |
| tShortAbandon Min | tShortAbandon Min | QueueHistory | |
| tShortAbandon Time | tShortAbandon Time | QueueHistory | |
| tFlowout Count | tFlowout Count | The amount of time before an interaction was transferred out of a queue (and not answered by an agent). | QueueHistory |
| tFlowout Time | tFlowout Sum | QueueHistory | |
| oInteracting | oInteracting Count | Observed number of current users interacting on PureCloud. | QueueObservations |
| oWaiting | oWaiting Count | Observed number of interactions waiting in a queue. | QueueObservations |
| ActiveAgents Count | QueueObservations | ||
| MemberUsers Count | QueueObservations | ||
| OffQueueAgents Count | QueueObservations | ||
| OnQueueAgents Count | QueueObservations | ||
| OnQueueAgents Idle Count | QueueObservations | ||
| OnQueueAgents Interacting Count | QueueObservations | ||
| OnQueueAgents Not Responding Count | QueueObservations |
Custom Measures
Each Index also include a number of measures which have been created as either a Custom Measure (KPI), Calculated Measure, or Virtual Member.
Agent History
| eMite Measure Name | Classification | eMite Measure Definition |
|---|---|---|
| % Answered | Custom Measures | ( [Predefined Measures].[tAnswered Count] / [Predefined Measures].[tAlert Count] ) * 100 |
| % Transferred | Custom Measures | ( [Predefined Measures].[nTransferred Count] / [Predefined Measures].[tAnswered Count] ) * 100 |
| Average ACW time | Custom Measures | [Predefined Measures].[tAcw Time] / [Predefined Measures].[tAcw Count] |
| Average Handle time | Custom Measures | [Predefined Measures].[tHandle Time] / [Predefined Measures].[tHandle Count] |
| Average Hold Complete time | Custom Measures | [Predefined Measures].[tHeldComplete Time] / [Predefined Measures].[tHeldComplete Count] |
| Average Talk Complete time | Custom Measures | [Predefined Measures].[tTalkComplete Time] / [Predefined Measures].[tTalkComplete Count] |
| Last Week Alert Count | Trend Measures | [Predefined Measures].[tAlert Count] FILTERED BY [Dimensions].[LinkedDate].[Date]=@LastWeek |
| Last Week Complete Talk time | Trend Measures | [Predefined Measures].[tTalkComplete Time] FILTERED BY [Dimensions].[LinkedDate].[Date]=@LastWeek |
| This Week Alert Count | Trend Measures | [Predefined Measures].[tAlert Count] FILTERED BY [Dimensions].[LinkedDate].[Date]=@ThisWeek |
| This Week Complete Talk time | Trend Measures | [Predefined Measures].[tTalkComplete Time] FILTERED BY [Dimensions].[LinkedDate].[Date]=@ThisWeek |
| Today ACW Max | Trend Measures | [Predefined Measures].[tAcw Max] FILTERED BY [Dimensions].[LinkedDate].[Date]=@Today |
| Today Average Hold Complete time | Trend Measures | [Custom Measures].[Average Hold Complete time] FILTERED BY [Dimensions].[LinkedDate].[Date]=@Today |
Agent Observations
| eMite Measure Name | Classification | Measure Definition |
|---|---|---|
| Routing On Queue | Custom Measures | SUM({[RoutingStatus].[RoutingStatus].[Idle],[RoutingStatus].[RoutingStatus].[Interacting],[RoutingStatus].[RoutingStatus].[Not_Responding]} * [Measures].[agentobservations_emite Count]) |
| Routing Off Queue | Custom Measures | [Measures.agentobservations_emite Count], FILTER [RoutingStatus.RoutingStatus.OffQueue] |
| Available | Custom Measures | [Measures.agentobservations_emite Count], FILTER [Presence.Presence.Available] |
| Busy | Custom Measures | [Measures.agentobservations_emite Count], FILTER [Presence.Presence.Busy] |
| Idle | Custom Measures | [Measures.agentobservations_emite Count], FILTER [Presence.Presence.Idle] && [Measures.agentobservations_emite Count], FILTER [RoutingStatus.RotingStatus.Idle] |
| Meal | Custom Measures | [Measures.agentobservations_emite Count], FILTER [Presence.Presence.Meal] |
| Meeting | Custom Measures | [Measures.agentobservations_emite Count], FILTER [Presence.Presence.Meeting] |
| Offline | Custom Measures | [Measures.agentobservations_emite Count], FILTER [Presence.Presence.Offline] |
| Org On Queue | Custom Measures | [Measures.agentobservations_emite Count], FILTER [Presence.Presence.On Queue] |
| Other | Custom Measures | [Measures.agentobservations_emite Count], FILTER [Presence.Presence.Away,Break,Busy,Meeting,Training,Idle] |
| Training | Custom Measures | [Measures.agentobservations_emite Count], FILTER [Presence.Presence.Training] |
| Interacting | Custom Measures | [Measures.agentobservations_emite Count], FILTER [RoutingStatus.RoutingStatus.Interacting] |
| Not Responding | Custom Measures | [Measures.agentobservations_emite Count], FILTER [RoutingStatus.RoutingStatus.NotResponding] |
| Ready | Custom Measures | [ Measures.Default.agentobservations_emite Count ], FILTER [Presence.Presence.On Queue] && [Call.call.false] && [Chat.chat.false] && [Email.email.false] |
Call Segments
| eMite Measure Name | Classification | eMite Measure Definition |
|---|---|---|
| % ACD Disconnected | Custom Measures | ( [Custom Measures].[ACD Disconnected Count] / [Custom Measures].[ACD Offered Count] ) * 100 |
| % Ivr to Acd | Custom Measures | ( [Custom Measures].[ACD Offered Count] / [Custom Measures].[IVR Offered Count] ) * 100 |
| % System to Ivr | Custom Measures | ( [Custom Measures].[IVR Offered Count] / [Custom Measures].[System Offered Count] ) * 100 |
| ACD Disconnect 000-030 | Custom Measures | [Custom Measures].[ACD Disconnected Count] FILTERED BY [Dimensions].[SegmentTimeBucket].[000 - 030 seconds] |
| ACD Disconnect 030-060 | Custom Measures | [Custom Measures].[ACD Disconnected Count] FILTERED BY [Dimensions].[SegmentTimeBucket].[030 - 060 seconds] |
| ACD Disconnect 060-120 | Custom Measures | [Custom Measures].[ACD Disconnected Count] FILTERED BY [Dimensions].[SegmentTimeBucket].[060 - 120 seconds] |
| ACD Disconnect 120-300 | Custom Measures | [Custom Measures].[ACD Disconnected Count] FILTERED BY [Dimensions].[SegmentTimeBucket].[120 - 300 seconds] |
| ACD Disconnect 300-3600 | Custom Measures | [Custom Measures].[ACD Disconnected Count] FILTERED BY [Dimensions].[SegmentTimeBucket].[300 - 3600 seconds] |
| ACD Disconnected Count | Custom Measures | [Predefined Measures].[Default callsegments Count] FILTERED BY ( [Dimensions].[Purpose].[Acd] AND [Dimensions].[SegmentType].[Interact] AND [Dimensions].[direction].[inbound] AND [Dimensions].[DisconnectType].[Peer] ) |
| ACD Offered Count | Custom Measures | ( [Custom Measures].[IVR Offered Count] - [Custom Measures].[ACD Disconnected Count] |
| IVR Disconnected Count | Custom Measures | [Predefined Measures].[Default callsegments Count] FILTERED BY ( [Dimensions].[Purpose].[Ivr] AND [Dimensions].[SegmentType].[Ivr] AND [Dimensions].[direction].[inbound] AND ([Dimensions].[DisconnectType].[Peer] OR [System]) ) |
| IVR Offered Count | Custom Measures | ( [Custom Measures].[System Offered Count] - [Custom Measures].[IVR Disconnected Count] |
| System Offered Count | Custom Measures | [Predefined Measures].[Default callsegments Count] FILTERED BY ( ([Dimensions].[Purpose].[Customer] OR [External]) AND [Dimensions].[SegmentType].[System] AND [Dimensions].[direction].[inbound] ) |
Queue History
| eMite Measure Name | Classification | Measure Definition | PureCloud Definition |
|---|---|---|---|
| % Abandoned for nOffered | Custom Measures | ( `[Predefined Measures].[tAbandon Count ] / [ Predefined Measures].[nOffered Count ] ) * 100 | Calculated by: (Abandoned Count / Offered Count) * 100 |
| % Answered for nOffered | KPI / Custom Measures | ( [ Predefined Measures.tAnswered Count ] / [ Predefined Measures.nOffered Count ] ) * 100 | |
| % Transferred for tHandle | KPI / Custom Measures | ( [ Predefined Measures.nTransferred Count ] / [ Predefined Measures.tHandle Count ] ) * 100 | |
| Average ACW time | KPI / Custom Measures | ( [ Predefined Measure.tACW Sum ] / [ Predefined Measures.tAnswered Count ] ) | Calculated by: Total ACW / Interactions |
| Average answered count | KPI / Custom Measures | ( [ Predefined Measures.tAnswered Count ] / [ Predefined Measures.tWait Count ] ) | |
| Average handle time | KPI / Custom Measures | ( [ Predefined Measure.tHandle Sum ] / [ Predefined Measures.tHandle Count ] ) | |
| Average hold time | KPI / Custom Measures | ( [ Predefined Measure.tHeldComplete Sum ] / [ Predefined Measures.tHeldComplete Count ] ) | Calculated by: Total Hold Time / Count of interactions with holds |
| Average speed of answer | KPI / Custom Measures | ( [ Predefined Measure.tAnswered Sum ] / [ Predefined Measures.tAnswered Count ] ) | Calculated by: Total Time to Answer / Number Answered |
| Average talk time | KPI / Custom Measures | ( [ Predefined Measure.tTalkComplete Sum ] / [ Predefined Measures.tTalkComplete Count ] ) | Calculated by: Total Talk time/ Count of interactions with Talk time |
| Average wait time | KPI / Custom Measures | ( [ Predefined Measure.tWait Sum ] / [ Predefined Measures.tWait Count ] ) | Calculated by: Total Wait Time / Interactions |
| Grade of Service | KPI / Custom Measures | ( [ Custom Measures.ServiceLevel Count ] / [ Custom Measures.Legacy tWait Count ] ) * 100 | Calculated by: (Number of answered interactions - number of answered interactions that miss the service level target)/ (Number of answered interactions + number of abandoned interactions)*100 |
| Legacy tWait Count | KPI / Custom Measures | ( [ Predefined Measures.tAnswered Count ] + [ Predefined Measures.tAbandon Count ] ) | |
| Legacy tWait Sum | KPI / Custom Measures | ( [ Predefined Measures.tAnswered Sum ] + [ Predefined Measures.tAbandon Sum ] ) | |
| OutsideSLA Count | KPI / Custom Measures | ( [Predefined Measures.nOverSla Count ] + [ Predefined Measures.tFlowout Count ] ) | |
| ServiceLevel Count | KPI / Custom Measures | ( [Predefined Measures.tAnswered Count ] - [ Custom Measures.OutsideSLA Count ] ) | |
| Simple Grade of Service | KPI / Custom Measures | ( [ Custom Measures.UnderSLA Count ] / [ Predefined Measures.tWait Count ] ) | |
| UnderSLA Count | KPI / Custom Measures | ( [ Predefined Measures.tAnswered Count ] - [ Predefined Measures.nOverSLA Count ] ) | |
| Seconds to Minutes Conversion | KPI / Static Measures | 60 (This is designed to be used as a multiplier for Advanced KPI creation) | |
| Performance Score Value | KPI / Static Measures | 5 (This is a placeholder value, designed to be used as a multiple for Advanced KPI creation) | |
| 7 Days Ago Abandoned Count | KPI / Trend Measures | ( [ Trend Measures.Last 7 Days Abandoned Count ] - [ Trend Measures.Last 6 Days Abandoned Count ] ) | |
| 7 Days Ago Answered Count | KPI / Trend Measures | ( [ Trend Measures.Last 7 Days Answered Count ] - [ Trend Measures.Last 6 Days Answered Count ] ) | |
| 7 Days Age Answered Sum | KPI / Trend Measures | ( [ Trend Measures.Last 7 Days Answered Sum ] - [ Trend Measures.Last 6 Days Answered Sum ] ) | |
| 7 Days Ago ASA | KPI / Trend Measures | ( [ Trend Measures.7 Days Ago Answered Sum ] / [ Trend Measures.7 Days Ago Answered Count ] ) | |
| 7 Days Ago Grade of Service | KPI / Trend Measures | ( [ Trend Measures.7 Days Ago Service Level Count ] / [ Trend Measures.7 Days Ago Legacy tWait Count ] ) * 100 | |
| 7 Days Ago Handled Count | KPI / Trend Measures | ( [ Trend Measures.Last 7 Days Handled Count ] - [ Trend Measures.Last 6 Days Handled Count ] ) | |
| 7 Days Ago Legacy tWait Count | KPI / Trend Measures | ( [ Trend Measures.7 Days Ago Abandoned Count ] + [ Trend Measures.7 Days Ago Answered Count ] ) | |
| 7 Days Ago Offered Count | KPI / Trend Measures | ( [ Trend Measures.Last 7 Days Offered Count ] - [ Trend Measures.Last 6 Days Offered Count ] ) | |
| 7 Days Ago OutsideSLA Count | KPI / Trend Measures | ( [ Trend Measures.Last 7 Days OutsideSLA Count ] - [ Trend Measures.Last 6 Days OutsideSLA Count ] ) | |
| 7 Days Ago Performance Score | KPI / Trend Measures | ( [ Trend Measures.Last 7 Days Performance Score ] - [ Trend Measures.Last 6 Days Performance Score ] ) | |
| 7 Days Ago Service Level Count | KPI / Trend Measures | ( [ Trend Measures.7 Days Ago Answered Count ] - [ Trend Measures.7 Days Ago OutsideSLA Count ] ) | |
| Last 6 Days % Abandoned | KPI / Trend Measures | ( [ Custom Measures.% Abandoned ] WHERE [ Filter.LinkedDate.Date ]=@Last6Days ) | |
| Last 6 Days % Answered | KPI / Trend Measures | ( [ Custom Measures.% Answered ] WHERE [ Filter.LinkedDate.Date ]=@Last6Days ) | |
| Last 6 Days Abandoned Count | KPI / Trend Measures | ( [ Predefined Measures.tAbandoned Count ] WHERE [ Filter.LinkedDate.Date ]=@Last6Days ) | |
| Last 6 Days Answered Count | KPI / Trend Measures | ( [ Predefined Measures.tAnswered Count ] WHERE [ Filter.LinkedDate.Date ]=@Last6Days ) | |
| Last 6 Days Answered Sum | KPI / Trend Measures | ( [ Predefined Measures.tAnswered Sum ] WHERE [ Filter.LinkedDate.Date ]=@Last6Days ) | |
| Last 6 Days ASA | KPI / Trend Measures | ( [ Custom Measures.Average speed of answer ] WHERE [ Filter.LinkedDate.Date ]=@Last6Days ) | |
| Last 6 Days Grade of Service | KPI / Trend Measures | ( [ Custom Measures.Grade of Service ] WHERE [ Filter.LinkedDate.Date ]=@Last6Days ) | |
| Last 6 Days Handled Count | KPI / Trend Measures | ( [ Predefined Measures.tHandle Count ] WHERE [ Filter.LinkedDate.Date ]=@Last6Days ) | |
| Last 6 Days Offered Count | KPI / Trend Measures | ( [ Predefined Measures.nOffered Count ] WHERE [ Filter.LinkedDate.Date ]=@Last6Days ) | |
| Last 6 Days OutsideSLA Count | KPI / Trend Measures | ( [ Predefined Measures.nOverSLA Count ] WHERE [ Filter.LinkedDate.Date ]=@Last6Days + [ Predefined Measures.tFlowout Count ] WHERE [ Filter.LinkedDate.Date ]=@Last6Days ) | |
| Last 6 Days Performance Score | KPI / Trend Measures | ( [ Trend Measures.Last 6 Days Answered Count ] * [ Static Measures.Performance Score ] ) | |
| Last 7 Days % Abandoned | KPI / Trend Measures | ( [ Custom Measures.% Abandoned ] WHERE [ Filter.LinkedDate.Date ]=@Last7Days ) | |
| Last 7 Days % Answered | KPI / Trend Measures | ( [ Custom Measures.% Answered ] WHERE [ Filter.LinkedDate.Date ]=@Last7Days ) | |
| Last 7 Days Abandoned Count | KPI / Trend Measures | ( [ Predefined Measures.tAbandoned Count ] WHERE [ Filter.LinkedDate.Date ]=@Last7Days ) | |
| Last 7 Days Answered Count | KPI / Trend Measures | ( [ Predefined Measures.tAnswered Count ] WHERE [ Filter.LinkedDate.Date ]=@Last7Days ) | |
| Last 7 Days Answered Sum | KPI / Trend Measures | ( [ Predefined Measures.tAnswered Sum ] WHERE [ Filter.LinkedDate.Date ]=@Last7Days ) | |
| Last 7 Days ASA | KPI / Trend Measures | ( [ Custom Measures.Average speed of answer ] WHERE [ Filter.LinkedDate.Date ]=@Last7Days ) | |
| Last 7 Days Average handle time | KPI / Trend Measures | ( [ Custom Measures.Average handle time ] WHERE [ Filter.LinkedDate.Date ]=@Last7Days ) | |
| Last 7 Days Grade of Service | KPI / Trend Measures | ( [ Custom Measures.Grade of Service ] WHERE [ Filter.LinkedDate.Date ]=@Last7Days ) | |
| Last 7 Days Handled Count | KPI / Trend Measures | ( [ Predefined Measures.tHandle Count ] WHERE [ Filter.LinkedDate.Date ]=@Last7Days ) | |
| Last 7 Days Offered Count | KPI / Trend Measures | ( [ Predefined Measures.nOffered Count ] WHERE [ Filter.LinkedDate.Date ]=@Last7Days ) | |
| Last 7 Days OutsideSLA Count | KPI / Trend Measures | ( [ Predefined Measures.nOverSLA Count ] WHERE [ Filter.LinkedDate.Date ]=@Last7Days + [ Predefined Measures.tFlowout Count ] WHERE [ Filter.LinkedDate.Date ]=@Last7Days ) | |
| Last 7 Days Performance Score | KPI / Trend Measures | ( [ Trend Measures.Last 7 Days Answered Count ] * [ Static Measures.Performance Score ] ) | |
| Today % Abandoned | KPI / Trend Measures | ( [ Custom Measures.% Abandoned ] WHERE [ Filter.LinkedDate.Date ]=@Today ) | |
| Today % Answered | KPI / Trend Measures | ( [ Custom Measures.% Answered ] WHERE [ Filter.LinkedDate.Date ]=@Today ) | |
| Today Abandoned Count | KPI / Trend Measures | ( [ Predefined Measures.tAbandoned Count ] WHERE [ Filter.LinkedDate.Date ]=@Today ) | |
| Today Answered Count | KPI / Trend Measures | ( [ Predefined Measures.tAnswered Count ] WHERE [ Filter.LinkedDate.Date ]=@Today ) | |
| Today ASA | KPI / Trend Measures | ( [ Custom Measures.Average speed of answer ] WHERE [ Filter.LinkedDate.Date ]=@Today ) | |
| Today Average wait time | KPI / Trend Measures | ( [ Custom Measures.Average wait time ] WHERE [ Filter.LinkedDate.Date ]=@Today ) | |
| Today Grade of Service | KPI / Trend Measures | ( [ Custom Measures.Grade of Service ] WHERE [ Filter.LinkedDate.Date ]=@Today ) | |
| Today Handled Count | KPI / Trend Measures | ( [ Predefined Measures.tHandle Count ] WHERE [ Filter.LinkedDate.Date ]=@Today ) | |
| Today Max wait time | KPI / Trend Measures | ( [ Predefined Measures.tWait Max ] WHERE [ Filter.LinkedDate.Date ]=@Today ) | |
| Today Offered Count | KPI / Trend Measures | ( [ Predefined Measures.nOffered Count ] WHERE [ Filter.LinkedDate.Date ]=@Today ) | |
| Today Performance Score | KPI / Trend Measures | ( [ Trend Measures.Today Answered Count ] * [ Static Measures.Performance Score Value ] ) | |
| WTD % Abandoned | KPI / Trend Measures | ( [ Custom Measures.% Abandoned ] WHERE [ Filter.LinkedDate.Date ]=@ThisWeek ) | |
| WTD % Answered | KPI / Trend Measures | ( [ Custom Measures.% Answered ] WHERE [ Filter.LinkedDate.Date ]=@ThisWeek ) | |
| WTD Abandoned Count | KPI / Trend Measures | ( [ Predefined Measures.tAbandoned Count ] WHERE [ Filter.LinkedDate.Date ]=@ThisWeek ) | |
| WTD Answered Count | KPI / Trend Measures | ( [ Predefined Measures.tAnswered Count ] WHERE [ Filter.LinkedDate.Date ]=@ThisWeek ) | |
| WTD ASA | KPI / Trend Measures | ( [ Custom Measures.Average speed of answer ] WHERE [ Filter.LinkedDate.Date ]=@ThisWeek ) | |
| WTD Grade of Service | KPI / Trend Measures | ( [ Custom Measures.Grade of Service ] WHERE [ Filter.LinkedDate.Date ]=@ThisWeek ) | |
| WTD Handled Count | KPI / Trend Measures | ( [ Predefined Measures.tHandle Count ] WHERE [ Filter.LinkedDate.Date ]=@ThisWeek ) | |
| WTD Offered Count | KPI / Trend Measures | ( [ Predefined Measures.nOffered Count ] WHERE [ Filter.LinkedDate.Date ]=@ThisWeek ) | |
| WTD Performance Score | KPI / Trend Measures | ( [ Trend Measures.WTD Answered Count ] * [ Static Measures.Performance Score Value ] ) | |
| Yesterday % Abandoned | KPI / Trend Measures | ( [ Custom Measures.% Abandoned ] WHERE [ Filter.LinkedDate.Date ]=@Yesterday ) | |
| Yesterday % Answered | KPI / Trend Measures | ( [ Custom Measures.% Answered ] WHERE [ Filter.LinkedDate.Date ]=@Yesterday ) | |
| Yesterday Abandoned Count | KPI / Trend Measures | ( [ Predefined Measures.tAbandoned Count ] WHERE [ Filter.LinkedDate.Date ]=@Yesterday ) | |
| Yesterday Answered Count | KPI / Trend Measures | ( [ Predefined Measures.tAnswered Count ] WHERE [ Filter.LinkedDate.Date ]=@Yesterday ) | |
| Yesterday ASA | KPI / Trend Measures | ( [ Custom Measures.Average speed of answer ] WHERE [ Filter.LinkedDate.Date ]=@Yesterday ) | |
| Yesterday Grade of Service | KPI / Trend Measures | ( [ Custom Measures.Grade of Service ] WHERE [ Filter.LinkedDate.Date ]=@Yesterday ) | |
| Yesterday Handled Count | KPI / Trend Measures | ( [ Predefined Measures.tHandle Count ] WHERE [ Filter.LinkedDate.Date ]=@Yesterday ) | |
| Yesterday Offered Count | KPI / Trend Measures | ( [ Predefined Measures.nOffered Count ] WHERE [ Filter.LinkedDate.Date ]=@Yesterday ) | |
| Yesterday Performance Score | KPI / Trend Measures | ( [ Trend Measures.Yesterday Answered Count ] * [ Static Measures.Performance Score Value ] ) |
Queue Observations
| eMite Measure Name | Classification | Measure Defintion | PureCloud Definition |
|---|---|---|---|
| Voice Interactions Waiting | Custom Measures | [ Predefined Measures.oWaiting ] WHERE [ Dimensions.MediaType.Voice ] |
- No labels