Forum Discussion
Solved
How to correlate time-based events
I am gathering data from two different logging systems. Both have a user, event, and a log datetime. The logs are gathered on different machines and so may have slight differences in their system clo...
I like this idea.
I might massage it a bit because I think I'm not just correlating two events, but rather clustering multiple events that occur within the same time period. Anyway, your suggestion has allowed me to progress, thanks!
Mike
Hi xhead,
I'm just wondering if you can convert your time columns to number of seconds first, then use ABS function in the filter of your calculation in this scenario? :smileylol:
EventInBothTable=
CALCULATE (
LOOKUPVALUE ( table2[event], table2[event], EARLIER ( table1[event] ) ),
FILTER ( table2, ABS ( table2[time] - EARLIER ( table1[time] ) ) <= 5 )
)
Regards
I like this idea.
I might massage it a bit because I think I'm not just correlating two events, but rather clustering multiple events that occur within the same time period. Anyway, your suggestion has allowed me to progress, thanks!
Mike