How to filter a Calculated Colums with a Partition in Datasphere

[hleboeuf]

Hello,

I'm a novice in DS, working for years in Azure and Informatica, so searching my way.

I have a issue in a view where I first create a calculated column like ROW_NUMBER() OVER (PARTITION BY CUSTOMER), its called xROW, until there works fine.

In the next 'block' I want to filter only the 1 values, but there I'm getting the error

The expression is using a calculated column which uses window function.

What is right, but why can't I filter on that column ? I would pfrefer to keep it in a graphical view as on long term we might involve more people and their SQL-coding skills are not that high.

[Cocquerel]

instead of (ROW_NUMBER() OVER (PARTITION BY CUSTOMER))=1

you may try CUSTOMER=FIRST_VALUE(CUSTOMER ORDER BY CUSTOMER)