Skip to Content
0

window function option in Webi report

Mar 14 at 11:11 AM

19

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded

can you share the screenshot of your data.

0
Former Member

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.
rep2.png (7.3 kB)
0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
AMIT KUMAR
Mar 14 at 12:12 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Many thanks, it works!

1