limit data by expression does not work when combine with OVER
i am using limit data by expression and Over function at the same time. i want to calculate the lowest rank group by schema_name. However its not functioning as i would imagine.
iam using Min([Rank]) over ([SCHEMA_NAME])
Can you provide your dxp with the data embedded? Also, can you clarify what you are trying to calculate in a bit more detail, perhaps with an example?