Choose Language Hide Translation Bar

Grouping measurement runs of different duration

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Grouping measurement runs of different duration

Try 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 )

)

)

2 REPLIES 2
Highlighted

Re: Grouping measurement runs of different duration

Try 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 )

)

)

Re: Grouping measurement runs of different duration

Thanks.  That worked great.

I'd never used the Lag function before.  Perfect.