OAS 2024 - data flow column expression for OVER PARTITION BY

User_TW8LE

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??

Chere-Oracle

Try this as the expression:

SUM( <measure name> BY <attribute name> )