Forum Discussion

Kaysa's avatar
Kaysa
New Member
1 year ago
Solved

Identify missed and returned calls

Hi there   When a call comes in the and the call is missed , i would like to know if the call was returned. When the Result is Missed, that identifies a "Missed Call". I would like to know if t...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Kaysa ,

    Based on the testing, please try the following methods:

    1.Create the sample table.

    2.Create the calculated column to identify if a missed call was returned.

    ReturnedCall = 
VAR ReturnedCalls = 
    FILTER(
        'Table',
        'Table'[Result] = "missed" &&
        'Table'[From] = EARLIER('Table'[To]) &&
        'Table'[Date] <= EARLIER('Table'[Date]) + 3
    )
RETURN
    IF('Table'[Result] = "answered", "answered",
        IF(COUNTROWS(RETURNEDCALLS) > 0, "Returned", "Not Returned")
    )

    3.The result is shown below.

     

    Best Regards,

    Wisdom Wu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Kaysa ,

Based on the testing, please try the following methods:

1.Create the sample table.

2.Create the calculated column to identify if a missed call was returned.

ReturnedCall = 
VAR ReturnedCalls = 
    FILTER(
        'Table',
        'Table'[Result] = "missed" &&
        'Table'[From] = EARLIER('Table'[To]) &&
        'Table'[Date] <= EARLIER('Table'[Date]) + 3
    )
RETURN
    IF('Table'[Result] = "answered", "answered",
        IF(COUNTROWS(RETURNEDCALLS) > 0, "Returned", "Not Returned")
    )

3.The result is shown below.

 

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.