How to group a dataset based on an attribute

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?

Find more posts tagged with

AI Studio

Accepted answers

All comments

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

aggregate_max.rmp

Quick Links

All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
Groups