Inbound SLT Range

This measure category contains measures built from FACT_INBOUND and existing measures of this category.

info

Main Focus is on measuring the Service Level based on different Service Level Threshold ranges of all inbound tasks.

Measure name = DAX formulas and expressions

Abandoned before 1 m = CALCULATE ( [Abandoned], FILTER( FACT_INBOUND, [AbandonWaitTime] < 60))

Abandoned before 10 m = CALCULATE ( [Abandoned], FILTER( FACT_INBOUND, [AbandonWaitTime] < 600))

Abandoned before 10 s = CALCULATE ( [Abandoned], FILTER( FACT_INBOUND, [AbandonWaitTime] < 10))

Abandoned before 2 m = CALCULATE ( [Abandoned], FILTER( FACT_INBOUND, [AbandonWaitTime] < 120))

Abandoned before 20 m = CALCULATE ( [Abandoned], FILTER( FACT_INBOUND, [AbandonWaitTime] < 1200))

Abandoned before 20 s = CALCULATE ( [Abandoned], FILTER( FACT_INBOUND, [AbandonWaitTime] < 20))

Abandoned before 30 s = CALCULATE ( [Abandoned], FILTER( FACT_INBOUND, [AbandonWaitTime] < 30))

Abandoned before 40 s = CALCULATE ( [Abandoned], FILTER( FACT_INBOUND, [AbandonWaitTime] < 40))

Abandoned before 5 m = CALCULATE ( [Abandoned], FILTER( FACT_INBOUND, [AbandonWaitTime] < 300))

Abandoned before 50 s = CALCULATE ( [Abandoned], FILTER( FACT_INBOUND, [AbandonWaitTime] < 50))

Answered before 1 m = CALCULATE ( [Answered], FILTER( FACT_INBOUND, [WaitTime] < 60))

Answered before 10 m = CALCULATE ( [Answered], FILTER( FACT_INBOUND, [WaitTime] < 600))

Answered before 10 s = CALCULATE ( [Answered], FILTER( FACT_INBOUND, [WaitTime] < 10))

Answered before 2 m = CALCULATE ( [Answered], FILTER( FACT_INBOUND, [WaitTime] < 120))

Answered before 20 m = CALCULATE ( [Answered], FILTER( FACT_INBOUND, [WaitTime] < 1200))

Answered before 20 s = CALCULATE ( [Answered], FILTER( FACT_INBOUND, [WaitTime] < 20))

Answered before 30 s = CALCULATE ( [Answered], FILTER( FACT_INBOUND, [WaitTime] < 30))

Answered before 40 s = CALCULATE ( [Answered], FILTER( FACT_INBOUND, [WaitTime] < 40))

Answered before 5 m = CALCULATE ( [Answered], FILTER( FACT_INBOUND, [WaitTime] < 300))

Answered before 50 s = CALCULATE ( [Answered], FILTER( FACT_INBOUND, [WaitTime] < 50))

Service Level 1 m (%) = DIVIDE([Answered before 1 m] , [Total Completed] - [Abandoned before 1 m] )

Service Level 10 m (%) = DIVIDE([Answered before 10 m] , [Total Completed] - [Abandoned before 10 m] )

Service Level 10 s (%) = DIVIDE([Answered before 10 s] , [Total Completed] - [Abandoned before 10 s] )

Service Level 2 m (%) = DIVIDE([Answered before 2 m] , [Total Completed] - [Abandoned before 2 m] )

Service Level 20 m (%) = DIVIDE([Answered before 20 m] , [Total Completed] - [Abandoned before 20 m] )

Service Level 20 s (%) = DIVIDE([Answered before 20 s] , [Total Completed] - [Abandoned before 20 s] )

Service Level 30 s (%) = DIVIDE([Answered before 30 s] , [Total Completed] - [Abandoned before 30 s] )

Service Level 40 s (%) = DIVIDE([Answered before 40 s] , [Total Completed] - [Abandoned before 40 s] )

Service Level 5 m (%) = DIVIDE([Answered before 5 m] , [Total Completed] - [Abandoned before 5 m] )

Service Level 50 s (%) = DIVIDE([Answered before 50 s] , [Total Completed] - [Abandoned before 50 s] )