BookmarkSubscribe
Choose Language Hide Translation Bar

Re: Merge data by time stamp

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

0 Kudos
KellyK
Community Trekker

Re: Merge data by time stamp

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. 

0 Kudos

Re: Merge data by time stamp

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?
0 Kudos
KellyK
Community Trekker

Re: Merge data by time stamp

That worked! Thank you!

0 Kudos

Re: Merge data by time stamp

Great :)

0 Kudos

Re: Merge data by time stamp

Unbenannt.PNG

0 Kudos