Skip to Content
avatar image
Former Member

remove duplicate rows based on one column in Web Intelligence report

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 16 at 01:24 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded