window function option in Webi report

[florin_stoica1]

Hi,

I'm looking for a way to replicate the functionality of a window function in Webi. One order can have multiple comments. I'm looking for a way to display in the report only the last comment and the user who commented. In a database there will be smth like RN=row_number()over (partition by [OrderNumber] order by [CommentDate] DESC). The RN for the last comment will be 1 and I will filter on 1 to only list the last comments. Is there a way to achieve thisin Webi?

[amitrathi239]

can you share the screenshot of your data.

[florin_stoica1]

The expected result is in the RN column. 1 represents the max Action Date. In this way, when I filter on 1 I will only have the max Action Date rows.

[amitrathi239 · Accepted solution]

try like this.

Var Show/Hide=if([Action Date]=Max([Action Date]) in ([Order]) then "Show" else "Hide"

Apply filter on var Show/Hide where equal to Show.

[florin_stoica1 · Accepted solution]

Many thanks, it works!