Count how often logs with dynamic field value that is the same gets emitted?

Question

I don't think this is possible, but wanted to ask anyway -- is there a way in Cloudwatch Insights where I can find the count of how often a log with a dynamic value is emitted with the same value from distinct logs? The use case I have is we want to compare log statements from two different code paths, so we attach the same requestID to both log statements. So to illustrate what might happen, two logs may get emitted

Log 1:

{ 
  message: "SPECIAL_LOG_EMITTED Operation1_Emitted"
  requestID: "123456"
}

Log2:

{ 
  message: "SPECIAL_LOG_EMITTED Operation2_Emitted"
  requestID: "123456"
}

So ideally I could do something like

fields @timestamp, @message, requestID
| filter @message like "SPECIAL_LOG_EMITTED"
| parse @message '*_Emitted' as operation
| stats count(*) as all, sum (operation LIKE 'Operation1') as Op1, sum (operation LIKE 'Operation2') as Operation2 by bin(5m)

And then from this find out where the requestID is matching. The requestID is dynamic, though, so I can't just hard-code it -- I want to find how often logs are emitted with matching requestIDs.

I've considered looking into count_distinct but that seems like the wrong approach (correct me if I'm wrong)