Forum Discussion
Kaysa
1 year agoNew Member
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...
- Anonymous1 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.
Ashish_Mathur
Super User
1 year agoHi,
Share data in a format that can be pasted in an MS Excel file. Show the expected result very clearly.
Lodewyk
Helper I
1 year agoAshish_Mathur , please see table as per your request
- Ashish_Mathur1 year ago
Super User
There is nothing i can understand there. Someone who does will help you.