
Hi there,
i want to eliminate multiple records and i want to show only one record if the value is same.please help. i'm attaching the workbook as well. I'm Exporting workbook in two versions latest 2019.1.7 and 10.5 as well.
Thanks
suresh.

Hi manoj,
i"m taking data from tableau server. it has huge data. i'm explaining my question clearly i want only single record instead of multiple if the data is same.if the data changes then i want that time interval as well that is max interval of changed record.i'm attaching the below screen shot.From the below screen shot i want only 10:30 record instead of same power factor measure for each interval and 11:00 clock again it changed to 0.01 .if it continuous same for 2:00 o clock i need 2:00 clock interval along with power factor value. eliminate rest of the intervals.