Grouping measurement runs of different duration<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />I have a column of data and a time stamp for a test performed over several minutes. The test consists of multiple bursts of data over this time period. I need to analyze each burst of data and compare statistics between bursts.
The problem is that the data has an irregular number of points. Each burst is separated by a few seconds, so I can use the time stamp to group the data. However, I haven't figured out how to make that work.
I can use the DIF function to figure out the transitions between groups, but I do not know how to increment a group number at this transition.
The goal would be to have a group number for each burst of data. Any ideas? I'm pretty handy with formula's but haven't done any scripting yet.
Thanks,
Scott
Re: Grouping measurement runs of different durationThanks. That worked great.
I'd never used the Lag function before. Perfect.
Re: Grouping measurement runs of different durationTry the column formula below. It should give each burst a number from 1 to 10 (if the table is sorted correctly).
If( Row() == 1,
1,
If( Dif( :Name( "Time (111447_138)" ), 1 ) > 1,
Lag( :Column 4, 1 ) + 1,
Lag( :Column 4, 1 )
)
)
