07-31-2017 03:54 AM
I have a exampleset with events including this properties:
- Init time
- End time
- Type of event
I want to detect anomalies based on the number of these event by date. But aggegrating these events using standar aggregation operator (by date) only takes into account dates with events, and there are quite dates dont have any. So, I suposse before aggregating I need to outer join events exampleset with a list of dates (between first and last day), because there are some days without events that have to be taken into account. How can I create this dates list? ¿Any other way to aggregate or count events in ALL days?
Thanks in advance.
07-31-2017 04:13 AM
Yes, an outer join with the additional dates you need is the standard procedure, just like with a database.
Aggregate will only work on the elements that are in the input.
07-31-2017 04:17 PM
There's a Generate Date Series operator in the Operator Toolbox extension.