Time series looks at lag but it doesn't show any correlation. I want to understand the following questions: 1. What is the lag between two the events when the relationship is the strongest? 2. Also, can the lag be used to predict the value of the Event B in the future.
Have you tried adding columns to your data table and then create formulas using the formula editor and then use the row>lag function and for each column have a lag 1 then lag 2.....lag n and then run the multivariate to see the correlation to the various lags?