I have a dataset containing two attributes: date time and occupancy number I want to have the maximum occupancy number in each day( no matter what hour), can anyone help me do this?
this can be done with the aggregate operator. You select the attribute to group on and you can then aggregate on sum, count, first , last or whatever is required
Within the aggregate operator, You have to set : In aggregation attributes : - set Occupancy as aggregation attribute and select maximum as aggregation function. In group by attributes : - select DateTime
You can find in attached file a process to help you.
Answers
Within the aggregate operator, You have to set :
In aggregation attributes :
- set Occupancy as aggregation attribute and select maximum as aggregation function.
In group by attributes :
- select DateTime
You can find in attached file a process to help you.
Regards,
Lionel