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

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- summarize mean data by group and only last number of data point

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

Highlighted
##
##### summarize mean data by group and only last number of data point

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

Jan 11, 2018 1:25 AM
(458 views)

hi,

I want to get the mean value of my "raw data" by a group of 3 different columns ("test name", "measurement name" and "entity") - this i can do by the summary option.

my problem is that I want only the last 13 points minimum (or last than 13 :) ) by date.

those are my columns

thanks for any help

Thanks, Adam

1 REPLY

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

You might want to check out the Statistical > Col Mean() formula. Create a new column with a formula ColMean(Raw_Value, test_name, measurement_name, entity). This will give the same means as the summary option but repeated across all rows.

If you order your table by date (decending), along with the other options you can create a formula which increments a counter and stops if the previous row and current row have different entity labels, etc.

You could then create a new column which copies the Raw_Value only if the counter is in the range 1-13. If you alter your first formula to point at this column, it will only take the means of these 13 or fewer values by entity.

If you order your table by date (decending), along with the other options you can create a formula which increments a counter and stops if the previous row and current row have different entity labels, etc.

You could then create a new column which copies the Raw_Value only if the counter is in the range 1-13. If you alter your first formula to point at this column, it will only take the means of these 13 or fewer values by entity.