topic Re: summarize mean data by group and only last number of data point in Discussions
https://community.jmp.com/t5/Discussions/summarize-mean-data-by-group-and-only-last-number-of-data-point/m-p/49547#M28174
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.<BR /><BR />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.<BR /><BR />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.Thu, 11 Jan 2018 16:09:08 GMTstephen_pearson2018-01-11T16:09:08Zsummarize mean data by group and only last number of data point
https://community.jmp.com/t5/Discussions/summarize-mean-data-by-group-and-only-last-number-of-data-point/m-p/49527#M28162
<P>hi,</P><P>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.</P><P>my problem is that I want only the last 13 points minimum (or last than 13 :) ) by date. </P><P>those are my columns </P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 756px;"><img src="https://kvoqx44227.i.lithium.com/t5/image/serverpage/image-id/8910i15F5BD6FDDD0CCEC/image-size/large?v=1.0&px=999" title="image.png" alt="image.png" /></span></P><P>thanks for any help </P>Thu, 11 Jan 2018 09:34:41 GMThttps://community.jmp.com/t5/Discussions/summarize-mean-data-by-group-and-only-last-number-of-data-point/m-p/49527#M28162AdamChoen2018-01-11T09:34:41ZRe: summarize mean data by group and only last number of data point
https://community.jmp.com/t5/Discussions/summarize-mean-data-by-group-and-only-last-number-of-data-point/m-p/49547#M28174
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.<BR /><BR />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.<BR /><BR />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.Thu, 11 Jan 2018 16:09:08 GMThttps://community.jmp.com/t5/Discussions/summarize-mean-data-by-group-and-only-last-number-of-data-point/m-p/49547#M28174stephen_pearson2018-01-11T16:09:08Z