Calling

This measure group contains measures built from vFACT_DETAILEDCALLHISTORY data and reused measures of this group.

info

Main focus is on measuring incoming and outgoing calls from Webex Calling application.

DAX formulas and expressions are displayed in a user-friendly format.

In Calls Answered = CALCULATE([Total Incoming Calls], FILTER([Answered] = 1), FILTER([AnswerIndicator] IN {"Yes","NA"}))

In Calls Answered (%) = [In Calls Answered] / [Total Incoming Calls]

In Calls Avg Duration (hh:mm:ss) = Format [In Calls Avg Duration (s)] in hh:mm:ss

In Calls Avg Duration (s) = [In Calls Duration (s)] / [Total Incoming Calls]

In Calls Duration (hh:mm:ss) = Format [In Calls Duration (s)] in hh:mm:ss

In Calls Duration (s) = CALCULATE(SUM([Duration]), FILTER([Direction] = "TERMINATING"))

In Calls Transferred = CALCULATE([In Calls Answered], FILTER([RelatedReason] IN {"Deflection","ConsultativeTransfer"}))

In Calls Transferred (%) = [In Calls Transferred] / [In Calls Answered]

In Calls Unanswered = [Total Incoming Calls] - [In Calls Answered]

In Calls Unanswered (%) = [In Calls Unanswered] / [Total Incoming Calls]

In Calls Unanswered Failure = CALCULATE([In Calls Unanswered], FILTER([CallOutcome] = "Failure"))

In Calls Unanswered NoA = CALCULATE([In Calls Unanswered], FILTER([CallOutcome] = "Success"), FILTER([AnswerIndicator] <> "Yes-PostRedirection"))

In Calls Unanswered Redirect = CALCULATE([In Calls Unanswered], FILTER([AnswerIndicator] = "Yes-PostRedirection"))

In Calls Unanswered Refusal = CALCULATE([In Calls Unanswered], FILTER([CallOutcome] = "Refusal"))

Out Calls Answered = CALCULATE([Total Outgoing Calls], FILTER([Answered] = 1), FILTER([AnswerIndicator] IN {"Yes","NA"}))

Out Calls Answered (%) = [Out Calls Answered] / [Total Outgoing Calls]

Out Calls Avg Duration (hh:mm:ss) = Format [Out Calls Avg Duration (s)] in hh:mm:ss

Out Calls Avg Duration (s) = [Out Calls Duration (s)] / [Total Outgoing Calls]

Out Calls Duration (hh:mm:ss) = Format [Out Calls Duration (s)] in hh:mm:ss

Out Calls Duration (s) = CALCULATE(SUM([Duration]), FILTER([Direction] = "ORIGINATING"))

Out Calls Unanswered = [Total Outgoing Calls] - [Out Calls Answered]

Out Calls Unanswered (%) = [Out Calls Unanswered] / [Total Outgoing Calls]

Total Call Legs = COUNT([ReportID])

Total Calls = DISTINCTCOUNT([CorrelationID])

Total External Calls = CALCULATE([Total Calls], FILTER([CallType] <> "SIP_ENTERPRISE"))

Total External In Calls = CALCULATE([Total Calls], FILTER([CallType] <> "SIP_ENTERPRISE"), FILTER([Direction] = "TERMINATING"))

Total External Out Calls = CALCULATE([Total Calls], FILTER([CallType] <> "SIP_ENTERPRISE"), FILTER([Direction] = "ORIGINATING"))

Total Incoming Call Legs = CALCULATE(COUNT([ReportID]), FILTER([Direction] = "TERMINATING"))

Total Incoming Calls = CALCULATE([Total Calls], FILTER([Direction] = "TERMINATING"))

Total Internal Calls = CALCULATE([Total Calls], FILTER([CallType] = "SIP_ENTERPRISE"))

Total Internal In Calls = CALCULATE([Total Calls], FILTER([CallType] = "SIP_ENTERPRISE"), FILTER([Direction] = "TERMINATING"))

Total Internal Out Calls = CALCULATE([Total Calls], FILTER([CallType] = "SIP_ENTERPRISE"), FILTER([Direction] = "ORIGINATING"))

Total Outgoing Call Legs = CALCULATE(COUNT([ReportID]), FILTER([Direction] = "ORIGINATING"))

Total Outgoing Calls = CALCULATE([Total Calls], FILTER([Direction] = "ORIGINATING"))