on ‎2018 Jan 16 1:19 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.