Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Counting events by date

jricgar

Hi all,

I have a exampleset with events including this properties:

- ID

- 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.

Find more posts tagged with

AI Studio

Accepted answers

All comments

BalazsBaranyRM

Hi!

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.

Regards,

Balázs

jricgar

That is what I thought. And, what would be the easiest way to get that list/exampleset using RM operators?

Thanks for your help

BalazsBaranyRM

There's a Generate Date Series operator in the Operator Toolbox extension.