Subscribe Bookmark RSS Feed

Grouping measurement runs of different duration

scottpenner

Community Trekker

Joined:

Apr 11, 2013

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
Solution

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
Solution

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 )

  )

)

scottpenner

Community Trekker

Joined:

Apr 11, 2013

Thanks.  That worked great.

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