Oracle Analytics Cloud and Server

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
26
Views
1
Comments

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