It's a cycle. First, the user sends the message as Msg1 to the system and the system responds with a reply 'your phone number has been verified'.
I need to see such users who sent the message as Msg1 but the system did not respond.
So this single table can be treated as two different tables
for every smssent event with 'Msg1'
there should be a corresponding smsreceived event with 'your phone number has been verified'
Now, wherever I'm missing the 'your phone number has been verified' event after getting the Msg1 from the user I need to count those.
Say 354 users sent the Msg1 to the system and
out of these 354 the system returned the 'your phone number has been verified' message only to 348 users. I want the resultant calculated field to return 6.
In the data set above, it should be 1.
Thank you for the reply.
I was able to get what I wanted.