Skip to Content
avatar image
Former Member

window function option in Webi report

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 14 at 12:12 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded