Hello,
I have the following in a webi report:
Aisle Unit Name Time
09 RW xyz 02/12/2018 04:12:44 PM
11 B xyz 02/12/2018 02:10:48 PM
I need to show the most recent time record
09 RW xyz 02/12/2018 04:12:44 PM
Can anyone help?
Thanks
Chuck
Best Answer
Feb 13 at 01:54 PM
what is the datatype of object?
if it's string then first convert in the date.
V date=Todate[Date];"MM/dd/yyyy hh:mm:ss a")
Create variable Show/Hide=If ([V date]=Max([V date]) in ([Name])) then "Show" else "Hide"
Apply the filter on SHow/Hide variable.
Feb 13 at 01:53 PM
Hi,
I would sort by type and date in my case and create a variable check to know the unique/first line, add filter on check =1 and I have the required result
