Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OAS 2024 - data flow column expression for OVER PARTITION BY
User_TW8LE
Rank 4 - Community Specialist
It seems like this might be possible in other (later?) versions of Oracle Analytics, but I'm working in OAS 2024, trying to build a data flow where I need to add a column and the expression needs to do the equivalent of SUM OVER PARTITION BY in SQL. It's already a complex design, so I'm not inclined to loop back and forth adding a bunch of steps to get to the end goal - really hoping there's a way to do it in the expression builder??
Tagged:
0
Answers
-
Try this as the expression:
SUM( <measure name> BY <attribute name> )
0
