turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Grouping measurement runs of different duration

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Apr 11, 2013 5:56 PM
(789 views)

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

**)**

**)**

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Apr 12, 2013 6:46 AM
(682 views)

Thanks. That worked great.

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