instead of multiple records for same value(power factor) i want max timestamp for each changed value
Hi there ,
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. for reference i'm attaching the sheet as well.
Hi Suresh,
I have already provided the answer for this thread in the following thread
I want Only one record instead of multiple times if the value is same
However,
Please use the following calculation
Power factor (No duplicates):
IF LOOKUP(AVG([Power Factor]),0)<>LOOKUP(AVG([Power Factor]),1) THEN AVG([Power Factor])
END
Drag this field on the rows
Right click on the field on the rows--> Compute using-->Table (down)
Exclude nulls by right click-->exclude nulls
or by creating another calculated field
filter null:
ISNULL(Power factor (No duplicates))==>drag this to filter and select false
Hope this helps!
If this reply helps, mark it as helpful and correct
Kindly close bot the threads!
Manoj
