Forum Discussion
xhead
Helper II
Helper IIHow 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
v-ljerr-msft
Microsoft Employee
Microsoft EmployeeHi 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
xheadHelper II
Helper III 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