I want to obtain the average values for some metrics for some given time intervals.
I have achieved it using IntervalMatch but my solution does not scale well when the EventLog grows.
Is there a way to perform an aggregation (avg, sum,…) within the interval match?
EventLog:
LOAD * Inline [
Time, Measurement
00:00, 0
01:18, 1
02:23, 2
04:15, 3
08:00, 4
11:43, 5
11:44, 5
11:45, 5
11:46, 8
];
OrderLog:
LOAD * INLINE [
Id,Start, End, Order
1,01:00, 03:35, A
2,02:30, 07:58, B
3,03:04, 10:27, C
4,07:23, 11:43, D
];
Inner Join IntervalMatch ( Time )
LOAD Start, End
Resident OrderLog;
/*
I don't want to perform all these joins
*/
Inner Join
LOAD Time, Measurement
Resident EventLog;
Out:
LOAD Id,AVG(Measurement) AS mean
Resident OrderLog
GROUP BY Id;
Drop Table EventLog;
