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

Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

smather Without sample data tough to be specific but I would just figure out what category I am in and then add the two together (10 seconds and 20 seconds). 

smather's avatar
smather
Helper III
4 years ago

Greg_Deckler Do you know how I'd add these figures up?