The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
"Generate Aggregation Attributes Over All Examples"
jaysunice3401
Member Posts: 6 
Contributor II
Here's the setup: I have a Location Attribute and a Revenue Attribute. Each Location is repeated multiple times. There are no missing values. I would like to Create / Generate two flavors of aggregation attributes:
+++
For a nice comparison, if I was using the Golf Example dataset, and pretend Outlook is my Location and Temperature is Revenue, I would like to mimic the following behavior:
Outlook Temp AvgTempByOutlook AvgTemp
sunny 85 76.2 73.6
sunny 80 76.2 73.6
overcast 83 75.0 73.6
rain 70 69.8 73.6
rain 68 69.8 73.6
rain 65 69.8 73.6
overcast 64 75.0 73.6
sunny 72 76.2 73.6
sunny 69 76.2 73.6
rain 75 69.8 73.6
sunny 75 76.2 73.6
overcast 72 75.0 73.6
overcast 81 75.0 73.6
rain 71 69.8 73.6
- An Average Revenue by Location
- An Average Revenue over all Loactions (exactly what is represented in the Meta Data)
+++
For a nice comparison, if I was using the Golf Example dataset, and pretend Outlook is my Location and Temperature is Revenue, I would like to mimic the following behavior:
Outlook Temp AvgTempByOutlook AvgTemp
sunny 85 76.2 73.6
sunny 80 76.2 73.6
overcast 83 75.0 73.6
rain 70 69.8 73.6
rain 68 69.8 73.6
rain 65 69.8 73.6
overcast 64 75.0 73.6
sunny 72 76.2 73.6
sunny 69 76.2 73.6
rain 75 69.8 73.6
sunny 75 76.2 73.6
overcast 72 75.0 73.6
overcast 81 75.0 73.6
rain 71 69.8 73.6
Tagged:
0
