How to group a dataset based on an attribute
Mahyar
New Altair Community Member
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?
I want to have the maximum occupancy number in each day( no matter what hour), can anyone help me do this?
Tagged:
0
Answers
-
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 required3
-
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 set0
-
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
0