How to group a dataset based on an attribute

Mahyar

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?

kayman

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

Mahyar

I cannot find out how it works. This is my data, I want to know how I can have each day and the maximum occupancy on a new example set

lionelderkrikor

Hi @Mahyar,

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