Merge data by time stamp

[#1]

Hi Kelly,

I'm glad that the summary function was of help. You mentioned you calculate the mean over the rounded timestamps. therefore you get the means just for those rounded timestamps. What I'm confused about is your comment on "the means are off a bit because the timestamps do not align". What do you expect from the mean to look like? Do you have comparison values or do you mean it would be good to have a mean for every exact time stamp?

Thanks,

Martin

[#2]

I'm happy with how the table looks. The numbers in the columns are off though. TagID 3322 does not have a timestamp at 4:10 PM, but when I do the mean function a SampleValue is in the 4:10 PM row. For the 4:20 PM timestamp, the SampleValue mean is not correct for the 3322 Tag. It averages the values for one of the 4:20 timestamps and one of the 4:30 timestamps. 

[#3]

I think I know what's going on here. The first column name is "Column 4 3317" which is not what you should have. There should be just "Column 4". Then you will see a empty value in Mean (SampleValue, 3322).
Please test the following in the table menu "Summary":
Group -> Column 4
Mean -> SampleValue
Subgroup -> TagID

Does that fix your issue?

[#4]

That worked! Thank you!

[#5]

Great :)

[#6]