@kcollori - Can you explain how this differs from (or adds requirements to) your use case in this question? https://answers.splunk.com/answers/578302/how-to-join-2-indexes-by-common-field-respective-t.html#answer-579343
When trying to connect something that is non-unique, you have to create uniqueness by a time limit or some other unique characteristic. That generally is going to require streamstats rather than eventstats .
You...
collect all the events that might be relevant,
sort them in order (remember sort 0 so you don't lose any),
copy the information you need from one type of record forward or
backward onto the other type of record using streamstats ,
get rid of any records that are now redundant
... occasionally eventstats is useful right here to collect remaining information together ...
then calculate and present your information.
... View more