How to group a dataset based on an attribute

Mahyar
Mahyar New Altair Community Member
edited November 2024 in Community Q&A
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?
Tagged:

Answers

  • kayman
    kayman New Altair Community Member
    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
    Mahyar New Altair Community Member
    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
    lionelderkrikor New Altair Community Member
    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