Forum Discussion

smather's avatar
smather
Helper III
4 years ago
Solved

Call Stats - Roll Up Figures

Hi 🙂    I have some call stat data I'm struggling with (my brain is refusing to work) and any help would be fab.    I have a col that sorts our calls like so:   Handled = IF('Call'[Contact Di...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi smather ,

    You can update the formula of your measure [TestMeasure] as below and check whether you can get the correct result.

    TestMeasure =
    VAR _selhandabdon =
    SELECTEDVALUE ( 'Call'[Handled and Abandoned] )
    VAR TenSecs =
    CALCULATE (
    SUM ( 'Call'[All Calls] ),
    FILTER (
    FILTER (
    ALLSELECTED ( 'Call' ),
    'Call'[Handled and Abandoned] = "Handled Within 10 Seconds"
    ),
    'Call'[X] <= MAX ( 'Call'[X] )
    )
    )
    VAR TwentySecs =
    CALCULATE (
    SUM ( 'Call'[All Calls] ),
    FILTER (
    FILTER (
    ALLSELECTED ( 'Call' ),
    'Call'[Handled and Abandoned] = "Handled Within 20 Seconds"
    ),
    'Call'[X] <= MAX ( 'Call'[X] )
    )
    )
    VAR ThirtySecs =
    CALCULATE (
    SUM ( 'Call'[All Calls] ),
    FILTER (
    FILTER (
    ALLSELECTED ( 'Call' ),
    'Call'[Handled and Abandoned] = "Handled Within 30 Seconds"
    ),
    'Call'[X] <= MAX ( 'Call'[X] )
    )
    )
    VAR SixtySecs =
    CALCULATE (
    SUM ( 'Call'[All Calls] ),
    FILTER (
    FILTER (
    ALLSELECTED ( 'Call' ),
    'Call'[Handled and Abandoned] = "Handled in SLT (60 Seconds)"
    ),
    'Call'[X] <= MAX ( 'Call'[X] )
    )
    )
    VAR Abandoned =
    CALCULATE (
    SUM ( 'Call'[All Calls] ),
    FILTER (
    FILTER ( ALLSELECTED ( 'Call' ), 'Call'[Handled and Abandoned] = "Abandoned" ),
    'Call'[X] <= MAX ( 'Call'[X] )
    )
    )
    RETURN
    IF (
    _selhandabdon = "Handled Within 10 Seconds",
    TenSecs,
    IF (
    _selhandabdon = "Handled Within 20 Seconds",
    TenSecs + TwentySecs,
    IF (
    _selhandabdon = "Handled Within 30 Seconds",
    TenSecs + TwentySecs + ThirtySecs,
    IF (
    _selhandabdon = "Handled in SLT (60 Seconds)",
    TenSecs + TwentySecs + ThirtySecs + SixtySecs,
    IF ( _selhandabdon = "Abandoned", Abandoned )
    )
    )
    )
    )

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi smather ,

You can update the formula of your measure [TestMeasure] as below and check whether you can get the correct result.

TestMeasure =
VAR _selhandabdon =
SELECTEDVALUE ( 'Call'[Handled and Abandoned] )
VAR TenSecs =
CALCULATE (
SUM ( 'Call'[All Calls] ),
FILTER (
FILTER (
ALLSELECTED ( 'Call' ),
'Call'[Handled and Abandoned] = "Handled Within 10 Seconds"
),
'Call'[X] <= MAX ( 'Call'[X] )
)
)
VAR TwentySecs =
CALCULATE (
SUM ( 'Call'[All Calls] ),
FILTER (
FILTER (
ALLSELECTED ( 'Call' ),
'Call'[Handled and Abandoned] = "Handled Within 20 Seconds"
),
'Call'[X] <= MAX ( 'Call'[X] )
)
)
VAR ThirtySecs =
CALCULATE (
SUM ( 'Call'[All Calls] ),
FILTER (
FILTER (
ALLSELECTED ( 'Call' ),
'Call'[Handled and Abandoned] = "Handled Within 30 Seconds"
),
'Call'[X] <= MAX ( 'Call'[X] )
)
)
VAR SixtySecs =
CALCULATE (
SUM ( 'Call'[All Calls] ),
FILTER (
FILTER (
ALLSELECTED ( 'Call' ),
'Call'[Handled and Abandoned] = "Handled in SLT (60 Seconds)"
),
'Call'[X] <= MAX ( 'Call'[X] )
)
)
VAR Abandoned =
CALCULATE (
SUM ( 'Call'[All Calls] ),
FILTER (
FILTER ( ALLSELECTED ( 'Call' ), 'Call'[Handled and Abandoned] = "Abandoned" ),
'Call'[X] <= MAX ( 'Call'[X] )
)
)
RETURN
IF (
_selhandabdon = "Handled Within 10 Seconds",
TenSecs,
IF (
_selhandabdon = "Handled Within 20 Seconds",
TenSecs + TwentySecs,
IF (
_selhandabdon = "Handled Within 30 Seconds",
TenSecs + TwentySecs + ThirtySecs,
IF (
_selhandabdon = "Handled in SLT (60 Seconds)",
TenSecs + TwentySecs + ThirtySecs + SixtySecs,
IF ( _selhandabdon = "Abandoned", Abandoned )
)
)
)
)

Best Regards

smather's avatar
smather
Helper III
4 years ago

Thank you Anonymous ! That's perfect, I really appreciate your help. ðŸ˜Š