Oracle Analytics

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

Received Response
31
Views
1
Comments
User_TW8LE
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??

Answers