Altair RISE
A program to recognize and reward our most engaged community members
Nominate Yourself Now!
Home
Discussions
Community Q&A
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?
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