Service Level for Call Stats

// This gives you the precentage of
// calls that were answered within
// less than 3 mins where the start
// of the call was within a certain
// time frame. The Dates table
// should be connected to your fact
// table on some date field which will
// mean "the day on which the call
// started." Let C be the fact table
// that you've shown. By the way,
// it's always better to give us raw
// data, not pictures. Nobody wants
// to type this data manually in.

[% Calls < 3] =
var __allCallsCount =
    COUNTROWS( C )
var __callsWithDurationLessThan3 =
    CALCULATE(
        COUNTROWS( C ),
        KEEPFILTERS(
            C[Less Than 3] = "Yes"
        )
    )
var __ratio =
    DIVIDE(
        __callsWithDurationLessThan3,
        __allCallsCount
    )
return
    __ratio