Skip to Content
0

remove duplicate rows based on one column in Web Intelligence report

Jan 16 at 01:19 PM

35

avatar image
Former Member

hello,

i need to edit a Web Intelligence report design to remove duplicate rows based on a column and retrieve only the latest value.

check above photo for more description.

sample.jpg (132.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Jan 16 at 01:24 PM
0

create variable Show/Hide=if([Submission date]=max([Submission date]) in (ID)) then "Show" else Hide"

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

Share
10 |10000 characters needed characters left characters exceeded