Version: 1.4

Inbound Buckets

This measure group contains measures built from vFACT_TASKLEGDETAILS data and re-uses the measures “Answered” and “Abandoned” from the Inbound measure group. It contains answered and abandoned measures for several wait time buckets.

info

Main focus is on measuring volumes for several wait time buckets.

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

Abandoned 00:00:00 - 00:00:10 = CALCULATE([Abandoned], FILTER([waitDuration] < 10000))

Abandoned 00:00:10 - 00:00:20 = CALCULATE([Abandoned], FILTER([waitDuration] >= 10000), FILTER([waitDuration] < 20000))

Abandoned 00:00:20 - 00:00:30 = CALCULATE([Abandoned], FILTER([waitDuration] >= 20000), FILTER([waitDuration] < 30000))

Abandoned 00:00:30 - 00:00:40 = CALCULATE([Abandoned], FILTER([waitDuration] >= 30000), FILTER([waitDuration] < 40000))

Abandoned 00:00:40 - 00:00:50 = CALCULATE([Abandoned], FILTER([waitDuration] >= 40000), FILTER([waitDuration] < 50000))

Abandoned 00:00:50 - 00:01:00 = CALCULATE([Abandoned], FILTER([waitDuration] >= 50000), FILTER([waitDuration] < 60000))

Abandoned 00:01:00 - 00:02:00 = CALCULATE([Abandoned], FILTER([waitDuration] >= 60000), FILTER([waitDuration] < 120000))

Abandoned 00:02:00 - 00:05:00 = CALCULATE([Abandoned], FILTER([waitDuration] >= 120000), FILTER([waitDuration] < 300000))

Abandoned 00:05:00 - 00:10:00 = CALCULATE([Abandoned], FILTER([waitDuration] >= 300000), FILTER([waitDuration] < 600000))

Abandoned 00:10:00 - 00:20:00 = CALCULATE([Abandoned], FILTER([waitDuration] >= 600000), FILTER([waitDuration] < 1200000))

Abandoned 00:20:00 - 01:00:00 = CALCULATE([Abandoned], FILTER([waitDuration] >= 1200000), FILTER([waitDuration] < 3600000))

Abandoned 01:00:00 + = CALCULATE([Abandoned], FILTER([waitDuration] >= 3600000))

Answered 00:00:00 - 00:00:10 = CALCULATE([Answered], FILTER([waitDuration] < 10000))

Answered 00:00:10 - 00:00:20 = CALCULATE([Answered], FILTER([waitDuration] >= 10000), FILTER([waitDuration] < 20000))

Answered 00:00:20 - 00:00:30 = CALCULATE([Answered], FILTER([waitDuration] >= 20000), FILTER([waitDuration] < 30000))

Answered 00:00:30 - 00:00:40 = CALCULATE([Answered], FILTER([waitDuration] >= 30000), FILTER([waitDuration] < 40000))

Answered 00:00:40 - 00:00:50 = CALCULATE([Answered], FILTER([waitDuration] >= 40000), FILTER([waitDuration] < 50000))

Answered 00:00:50 - 00:01:00 = CALCULATE([Answered], FILTER([waitDuration] >= 50000), FILTER([waitDuration] < 60000))

Answered 00:01:00 - 00:02:00 = CALCULATE([Answered], FILTER([waitDuration] >= 60000), FILTER([waitDuration] < 120000))

Answered 00:02:00 - 00:05:00 = CALCULATE([Answered], FILTER([waitDuration] >= 120000), FILTER([waitDuration] < 300000))

Answered 00:05:00 - 00:10:00 = CALCULATE([Answered], FILTER([waitDuration] >= 300000), FILTER([waitDuration] < 600000))

Answered 00:10:00 - 00:20:00 = CALCULATE([Answered], FILTER([waitDuration] >= 600000), FILTER([waitDuration] < 1200000))

Answered 00:20:00 - 01:00:00 = CALCULATE([Answered], FILTER([waitDuration] >= 1200000), FILTER([waitDuration] < 3600000))

Answered 01:00:00 + = CALCULATE([Answered], FILTER([waitDuration] >= 3600000))