Outdial

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

info

Main focus is on measuring outgoing calls from agents with any kind of phone but not related to a campaign.

The entire data is filtered with an additional FILTER([direction] = "outdial") and FILTER([isCampaign] = 0).

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

Outdial Abandoned = SUM([OutdialAbandoned])

Outdial Abandoned (%) = [Outdial Abandoned] / [Total Outdial Attempts]

Outdial Answered = SUM([OutdialAnswered])

Outdial Answered (%) = [Outdial Answered] / [Total Outdial Attempts]

Outdial Avg Connected Time (hh:mm:ss) = Format [Outdial Avg Connected Time (s)] in hh:mm:ss

Outdial Avg Connected Time (s) = [Outdial Connected Time (s)] / [Outdial Answered]

Outdial Avg Handle Time (hh:mm:ss) = Format [Outdial Avg Handle Time (s)] in hh:mm:ss

Outdial Avg Handle Time (s) = [Outdial Handle Time (s)] / [Outdial Answered]

Outdial Avg Hold Time (hh:mm:ss) = Format [Outdial Avg Hold Time (s)] in hh:mm:ss

Outdial Avg Hold Time (s) = [Outdial Hold Time (s)] / [Outdial Answered]

Outdial Avg Talk Time (hh:mm:ss) = Format [Outdial Avg Talk Time (s)] in hh:mm:ss

Outdial Avg Talk Time (s) = [Outdial Talk Time (s)] / [Outdial Answered]

Outdial Avg Wait Time (hh:mm:ss) = Format [Outdial Avg Wait Time (s)] in hh:mm:ss

Outdial Avg Wait Time (s) = [Outdial Wait Time (s)] / [Total Outdial Attempts]

Outdial Avg Wrapup Time (hh:mm:ss) = Format [Outdial Avg Wrapup Time (s)] in hh:mm:ss

Outdial Avg Wrapup Time (s) = [Outdial Wrapup Time (s)] / [Outdial Answered]

Outdial Connected Time (hh:mm:ss) = Format [Outdial Connected Time (s)] in hh:mm:ss

Outdial Connected Time (s) = [Outdial Talk Time (s)] + [Outdial Hold Time (s)]

Outdial Handle Time (hh:mm:ss) = Format [Outdial Handle Time (s)] in hh:mm:ss

Outdial Handle Time (s) = [Outdial Talk Time (s)] + [Outdial Hold Time (s)] + [Outdial Wrapup Time (s)]

Outdial Hold Time (hh:mm:ss) = Format [Outdial Hold Time (s)] in hh:mm:ss

Outdial Hold Time (s) = CALCULATE(sum([holdDuration]) / 1000, FILTER([direction] = "outdial"), FILTER([isCampaign] = 0), FILTER([endedDateId] > 0))

Outdial Incomplete = SUM([OutdialIncomplete])

Outdial Max. Handle Time (hh:mm:ss) = Format [Outdial Max. Handle Time (s)] in hh:mm:ss

Outdial Max. Handle Time (s) = CALCULATE(max([handleTime]) / 1000, FILTER([direction] = "outdial"), FILTER([isCampaign] = 0), FILTER([endedDateId] > 0))

Outdial Max. Hold Time (hh:mm:ss) = Format [Outdial Max. Hold Time (s)] in hh:mm:ss

Outdial Max. Hold Time (s) = CALCULATE(max([holdDuration]) / 1000, FILTER([direction] = "outdial"), FILTER([isCampaign] = 0), FILTER([endedDateId] > 0))

Outdial Max. Talk Time (hh:mm:ss) = Format [Outdial Max. Talk Time (s)] in hh:mm:ss

Outdial Max. Talk Time (s) = CALCULATE(max([connectedDuration]) / 1000, FILTER([direction] = "outdial"), FILTER([isCampaign] = 0), FILTER([endedDateId] > 0))

Outdial Max. Wrapup Time (hh:mm:ss) = Format [Outdial Max. Wrapup Time (s)] in hh:mm:ss

Outdial Max. Wrapup Time (s) = CALCULATE(max([wrapupDuration]) / 1000, FILTER([direction] = "outdial"), FILTER([isCampaign] = 0), FILTER([endedDateId] > 0))

Outdial Short Abandoned = SUM([OutdialShortAbandoned])

Outdial Talk Time (hh:mm:ss) = Format [Outdial Talk Time (s)] in hh:mm:ss

Outdial Talk Time (s) = CALCULATE(sum([connectedDuration]) / 1000, FILTER([direction] = "outdial"), FILTER([isCampaign] = 0), FILTER([endedDateId] > 0))

Outdial Wait Time (hh:mm:ss) = Format [Outdial Wait Time (s)] in hh:mm:ss

Outdial Wait Time (s) = CALCULATE(sum([waitDuration]) / 1000, FILTER([direction] = "outdial"), FILTER([isCampaign] = 0), FILTER([endedDateId] > 0))

Outdial Wrapup Time (hh:mm:ss) = Format [Outdial Wrapup Time (s)] in hh:mm:ss

Outdial Wrapup Time (s) = CALCULATE(sum([wrapupDuration]) / 1000, FILTER([direction] = "outdial"), FILTER([isCampaign] = 0), FILTER([endedDateId] > 0))

Total Outdial Attempts = [Outdial Answered] + [Outdial Abandoned]

Total Outdial Tasks = [Outdial Incomplete] + [Outdial Short Abandoned] + [Outdial Answered] + [Outdial Abandoned]

Total Outdial Tasks (create time) = CALCULATE([Total Outdial Tasks], USERELATIONSHIP('vBRIDGE_TIMEZONE'[DateIntId],[createdDateIntId]))